1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 ?

Question Posted / deepak tiwary

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

When do we use triggers?

0 Answers  

How can I speed up sql query?

0 Answers  

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

What is a full join?

0 Answers  

What is sqlcontext?

0 Answers  




What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

What is the difference between partitioning and sharding?

0 Answers  

Differentiate between pl/sql and sql?

0 Answers  

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

How many unique keys can a table have?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories