How to use fetch statement in a loop?
No Answer is Posted For this Question
Be the First to Post Answer
Explain a data segment?
how to we delete a row using varray
How many categories of data types in oracle?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
can a table has a column that has only view data and in other columns we can change data?
Define 'view' advantage ?
What is a initialization parameter file in oracle?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
What is the difference between online and offline backups?
Explain the use of Merge statement in oracle 11g
What the is the diff between local index and global index. give some example.
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?