We have a table customer and table car. customer table is defined as: cust#, transaction# car table is defined as: transaction#, car model#
I have a .NET app that retrieves a SYS_REFCURSOR output from an Oracle 9i stored proc.I would like to take that cursor and pass it into another stored proc to get a different one in return.
I\'m having a performance issue when deploying an app developed on 10g XE in a client\'s 9i server. The same query produces completely different query plans depending on the server:
I am running an Oracle 9i server at my office.I am working on a procedure that passes a sys_refcursor as an out parameter to another package (along with other in parameters).I was able to define a typ
I created a user defined function to delete some data. It doesn\'t work with delete but works with select. I am Oracle 9i.
I\'m working on an Oracle9i server in college. I have granted my friend select and insert permissions on a view\'v1\'.
I would like to check, is it possible to left join two tables using a non numeric column? i.e. where descriptions_cd is a varchar(10) and table_cd is a varchar(10):
Can anyone please tell me to use which jdbc driver to connect with oracle 9.0.1.1? i\'m using jdk1.6. i\'ve used classes12 and ojdbc6 but they are causing errors.
I am looking for a free tool that can analyzesORACLE 9i statspack report and recommend ways to optimize the DB.
I\'ve the follwing 2 versions of ANSI compliant SQL(column/table names changed to protect confidential data), of which one of them satisfies my requirement by following the right logic while the other
加载中,请稍侯......