Why cursor variables are easier to use than cursors?
No Answer is Posted For this Question
Be the First to Post Answer
What are the logical operations?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
When do we use group by clause in a sql query?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Briefly explain what is literal? Give an example where it can be used?
How to use regular expression in pattern match conditions in oracle?
What is rowid and rownum in oracle?
What happens to the indexes if a table is recovered?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
Define Transaction ?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?