Question:
Hi experts,
here is scenario
Environment: Oracle 10g 10.2, Windows
we have two DB servers running at remote locations connected via link
we have to insert data to a table in site B upon insertion/updation on a table at site A. ideally we should have defined a triger upon table of site A which in turn do further insertion [...]
Question:
Trying to exclude the row where A.sku=B.ordersku when the rentaldate is a specific value
SELECT * FROM dresses as A LEFT OUTER JOIN orders as B ON A.sku=B.ordersku WHERE A.occasion like ‘%Girls Night%’ OR A.occasion like ‘Girls Night%’ OR A.occasion like ‘%Girls Night’ AND A.dresssize <> ‘ ‘ AND EXISTS
(select *
from orders
where B.rentaldate NOT LIKE ‘2010-03-09%’)
Solution:
If [...]
Question:
Is it possible to use sql (in Oracle10g ) to have a date range that goes back to the last 2 months whenever the statement is ran; i.e. if I ran the sql on march 10, I would get results for the full months of jan & feb and if I ran it in july [...]
Question:
Hi Experts,
I reinstalled Oracle 10g client (with admin privilege) in my machine. But after that I couldn’t connect to toad. When I try to connect to the db with toad I am getting the following error message.
ORA-12154: TNS could not resolve the connect identifier
Can anybody help me in this?
Thanks
Dileep.
Solution:
Set TNS_ADMIN variable in the Registry that [...]
Question:
Does anyone knowwhat might be occuring here. Could it be an internal bug or soemthing with ode below.
I am uploading an XML text file over the web using MOD_PLSQL with some diacritics like
ALT+0224
ALT+0232
ALT+0225
one tag has “new word àèáñ”
MOD_PLSQL uploads files using binay by default into DOCUMENT_TABLE.
The binary file seems to be oK with diacritics in [...]
Question:
msiban2 0770 nat3700 error -204 with sqlstate 42704 from call to db2
db2 v4, ibm 390
Solution:
ok
are you sure you are working against the same db2 subsystem both in online and batch?
are you sure you are using the same user to run this in online and in batch?
Question:
Hi Experts,
I got a new computer that has Windows 7 64 bit Home Premium operating system on it.
I went to the oracle download page located here
http://www.oracle.com/technology/software/products/database/index.html
On my old computer I had 10g Express edition but when I looked at the system requirements page it didn’t list windows 7 as a supported operating system, so now [...]
Question:
I am actually a Java lover, but I am studying mysql right now. =]
I know it’s database system language and cannot be compare with other OO languages but..
Can anyone tell me the inheritance, exception handling or any other special characterstics of MySql has compared to other languages specifically?
Also, why is MySql famous if compared to [...]
Question:
As I work with phpMyAdmin my left from with the table list slowly grows smaller. This is not a problem in FireFox or IE because I can just move the slider between the left and main frames. But in Chrome I can move the cursor over the frame border (red ellipse in the attached image) [...]
Question:
Hi Experts,
I would like to ask a couple queries to a database and these queries should be optimized such that they run as fast as possible.
Therefore I would like to put the appropriate keys.
Earlier I had a problem with mixing types so that indices were not used:
http://www.experts-exchange.com/Database/MySQL/Q_25212720.html
Now, after resolving that issue I ran into the [...]