⟩ Explain the use of Control File?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
What is the MD form 50?
Can we change the profile value? How?
What is the difference between GL date and GL posted date?
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?