I have a stored procedure which returns a ref cursor as follows: CREATE OR REPLACE PROCEDURE AIRS.GET_LAB_REPORT (ReportCurTyp OUT sys_refcursor)
I am trying to export the source for a java object from an oracle database using the following code. DECLARE
I much prefer using this \'embedded\' style inserts in a pl/sql 开发者_高级运维block (opposed to the execute immediate style dynamic sql - where you have to delimit quotes etc).
Business logic is coded in pl/sql packages procedures and functions. Java programs call pl/sql packages procedures and functions to do database work.
I have a hierarchical table on Oracle pl/sql. something like: create table hierarchical ( idinteger prima开发者_JS百科ry key,
I\'d like to call a PL/SQL stored procedure that has an OUT parameter specified, but I don\'t care about the return value.I just care that the procedure executed successfully, i.e. no exceptions throw
I have a table with about 1 billion rows. I\'m开发者_如何学运维 the sole user so there\'s no contention on locks, etc.
Can someone provide an example of how to use parallel table function in oracle pl/sql. We need to run massive queries for 15 years and combine the r开发者_运维百科esult.
I\'m hoping someone can help me as I\'ve been stuck on this problem for a few days now. Basically I\'m trying to pull data from 3 tables in Oracle: 1) Orders Table 2) Vendor Table and 3) Master Data T
We have a lot of SP\'s and many of them take forever to execute.These SP\'s are pretty long and its a pain to go through the SP to find out which query is taking long.
加载中,请稍侯......