How can you find a PL/SQL block, if the cursor is open?

More Questions from Technology

• How can you generate debugging output from PL/SQL?
• State one similarity and difference between WHERE Clause and HAVING Clause?
• What are defaults? Is there a column to which a default can’t be bound?
• What are constraints? Mention the different types of constraints?
• What is the difference between a primary key and a unique key?
• What are the difference between clustered and a non-clustered index?
• What is difference between DELETE and TRUNCATE commands?
• Can SQL Servers linked to other servers like Oracle?
• What is Log Shipping?
• Where SQL server user names and passwords are stored in SQL server?

Discussion & Comments