⟩ What constitute an ORACLE Instance?
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
At what stage is the subledger data posted to GL?
In GL there is no org id. So how do we differentiate the data from different operating units?
Explian rowid, rownum?what are the psoducolumns we have?
What is difference b/w stored procedures and application procedures, stored function and application function?
what is the starting oracle error number? what is meant by forward declaration in functions?
In a Distributed Database System Can we execute two queries simultaneously? Justify?
How we can create a table in PL/SQL block. insert records into it? is it possible by some procedure or function? please give example?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
State the difference between implict and explict cursors?
How to know the last executed procedure?