What is transaction control statement and how many types of transaction control statement in Oracle?
what are stored procedures?
Why do you use stored procedures and state some of its disadvantages?
ABOUT IDENTITY?
what are corelated subqueries
What is the scope of a local variable?
What are the uses of linked server and explain it in detail?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
select trunc(round(156.00,-1),-1) from dual;
how to find find & delete duplicate rows from two different tables?
what are views?
How to handle a single quote in oracle sql?
What is the use of Control File ?