Each row in a cursor should be joined with another table and the whole result should开发者_如何学Python be returned a one cursor
I would like to run a PL/SQL procedure involving 80,000,000 records. This PL/SQL procedure deletes about 80,000,000 records, backupping them in a GLOBAL TEMPORARY TABLE created with the clause ON COM
How can I optimize this query if given the following query returns either all entries in the table or entries that match only up to current date ?
i have a Dimension Table like this : my_Table pk1Primary key pk2Primary key pk3Primary key col1 col2 col3 ...
When I am executing the package I get an error message: error in the emp_test ORA-06530: Reference to uninitialized composite
my table; Date|Cost 01.01.2010 |100 02.01.2010 |200 03.01.2010开发者_开发知识库 |300 04.01.2010 |400
I have a dynamic PL/SQL that will construct the SELECT statement based on what the searching criteria input from the users,likes:
What is t开发者_Go百科he best way to dynamically set the \'order by\' column name and direction from parameters passed in to a plsql procedure?You can use variables if you order using a case:
I am here to get records based on categories. My table foo has fields [id, name, class]. my records can be like:
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
加载中,请稍侯......