Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

Write a query to display the current date in sql?

0 Answers  

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

What is replication id?

0 Answers  

Which tcp/ip port does sql server run?

0 Answers  

What is type and rowtype in pl sql?

0 Answers  

Types of optimization?

6 Answers   Microsoft,

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

What is asqueryable?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories