How view is different from a table?
query optmization techniques and quwry analyser+projects+ppts
What is null value in oracle?
What is a trigger and what are its types?
Please explain compound trigger in oracle?
Can we save images in a database and if yes, how?
Give the constructs of a package, function or a procedure.
Explain joins in oracle?
how to get second highest sal of emp table
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
What is memory advisor in Oracle?
What are dml statements in oracle?
How to get a list of all user accounts in the database?