Table A Table B
1 1
2 1
3
1. Union & union all --> A Union B , A Union all B
2. Minus , Intersect --> A minus B , B Minus A , A Intersect B
3. Joins A join B , A Left Join B A Right Join B , A full Join B
4. %Type - Uses & Benifit
5. Truncate & Delete
6. Pragma Autonomus Transaction
7. how to Perform DDL from function or procedure
8. Can we have DML inside Function
9. Rank & Dense Rank diffrence
10. Water Mark in Oracle
11. Index , Can we have index in all column of table if no then why ?
No Answer is Posted For this Question
Be the First to Post Answer
What is sql query optimization?
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
Is pl sql a scripting language?
What is the function that is used to transfer a pl/sql table log to a database table?
what is subquery? : Sql dba
What are packages in pl sql and also explain its advantages?
What is the best sql course?
How do you delete duplicates in sql query using rowid?
What is sql scripting?
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?
What is keys and its types?
What are the various levels of constraints?