This was a question for Tom, but he is busy right now. I am not a DBA, just a simple Java EE developer, also I am new to Oracle, and I was asked to optimize some queries.
I have an update query like following: update table TABLE1 set COL1 = \'X\' where COL2 = \'Y\' ---1 Support the values \'X\' and \'Y\' are fetched from database now TABLE2. E.g.
My applicatino is giving ORA-12532: TNS:invalid argument开发者_开发技巧 exception. My app is in C# and I am using ODP.Net to connect to oracle database.
I\'ve been trying to installing JDeveloper and Weblogic server , and when trying to login as first time as Administrator in console of weblogic ,
Is there a space or other non-printing character I can insert to a varchar2 column that will not be trimmed away and result in a NULL?
I have 3 tables and I am joining these 2 tables as follows: SELECT EMP.FNAME,EMP.LNAME,EMP.AGE,EMPD.TQ,EMPD.TA,CTY.CITY_NAME FROM
I have created a database in oracle 11g. and now i 开发者_Go百科want to see table relationship diagrams like we can see in mssql server 2005.
How do I return a rowset consisting of the last four years based on the current d开发者_如何学Pythonate?
I have to connect to a Oracle server on the network using a .NET / C# (Winform) application. I am trying to use System.Data.OracleClient but in vain.
Statement below is working on Oracle 9i but not on Oracle 11g SELECT * FROM ( SELECT 0 scrnfail_rate, \'9\' zz, 7 hh FROM DUAL
加载中,请稍侯......