How to change sql*plus system settings?
what is the difference between implicit and explicit trigger
How would you hide a table in sql. ie the table can be only visible to its maker?
what does it mean to have quoted_identifier on? : Sql dba
create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
Why do we need unique key in a table?
What is benefit of creating memory optimized table?
What is the basic structure of PL/SQL ?
how to get a list of indexes of an existing table? : Sql dba
Determine if oracle date is on a weekend?
Show code of a cursor for loop.
Explain the two type of Cursors ?
What is difference between triggers and stored procedures. And advantages of SP over triggers ?