Why do we use %rowtype & %type in plsql?
What is sp_helptext?
diff b/w sub query and co-relater query?
if i perform any operation on views such as insert, delete etc will my base table get affected?????
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?
How to use distinct and count in sql query? Explain
Which is the correct statement about truncate and delete?
Does group by remove duplicates?
What is synchronized subquery?
What is memory optimized table?
Give the structure of the procedure ?
What are views in sql?