Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Post New Answer



More SQL PLSQL Interview Questions

What is the difference between explicit and implicit cursors in oracle?

0 Answers  


What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,


Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  


what is bdb (berkeleydb)? : Sql dba

0 Answers  


What are sql procedures?

0 Answers  






When sql appeared?

0 Answers  


Can a foreign key have a different name?

0 Answers  


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  


Is sql procedural language?

0 Answers  


difference between SQL and C

1 Answers   Indus Software Technologies,


what is a foreign key ? : Sql dba

0 Answers  


What is interval partition?

0 Answers  


Categories