What are the advantages of normalization?
What is pl/sql tables?
How to change the order of columns in Oracle SQL Plus ?
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?
List out the acid properties and explain?
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
what is the difference between char and varchar data types? : Sql dba
Tell me what a package consists of.
What are user defined stored procedures ?
what is rollback? : Sql dba
How many indexes can be created on a table in sql?
What is Highwatermark?