oracle9i

相关标签：javascript jquery android 多少钱 iPhone

Pl/SQL - oracle 9i

We have a table customer and table car. customer table is defined as: cust#, transaction# car table is defined as: transaction#, car model#[详细]

2023-03-10 01:17 分类：问答
Can i join on an inbound oracle cursor in a stored proc?

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.[详细]

2023-03-07 16:35 分类：问答
Make Oracle 9i use indexes

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:[详细]

2023-03-07 11:43 分类：问答
Get specific fields from sys_refcursor in stored proc?

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[详细]

2023-03-06 09:49 分类：问答
Can I delete rows using user defined functions in oracle?

I created a user defined function to delete some data. It doesn\'t work with delete but works with select. I am Oracle 9i.[详细]

2023-03-05 16:02 分类：问答
Views with Granted Select/Insert Permissions

I\'m working on an Oracle9i server in college. I have granted my friend select and insert permissions on a view\'v1\'.[详细]

2023-03-05 15:39 分类：问答
Not able to left join two tables using a non numeric column? ora-01722

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):[详细]

2023-03-04 20:29 分类：问答
Very little Jdbc issue

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.[详细]

2023-03-03 18:05 分类：问答
analyzing STATSPACK report

I am looking for a free tool that can analyzesORACLE 9i statspack report and recommend ways to optimize the DB.[详细]

2023-03-02 22:20 分类：问答
Oracle proprietary joins- joining on multiple conditions

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[详细]

2023-03-01 19:05 分类：问答