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...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

Cap Gemini, MTS,

4 12604

How to find only %th Highest Sal

Infogain, Symphony,

6 12488

How will you make performance better for application including front end and back

Metric Stream,

2 9928

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

CTS,

2 10707

What are the Diff B/W Cursor and REF Cursor

CTS,

3 13244

difference between table level constraint and column level and advantages of table level constraint

Doyensys,

4 15769

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

Doyensys, Infosys, Metric Stream,

5 19541

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 9416

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

GE,

2 5432

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

GE,

4 10114

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 3882

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 6473

when normalization is required

HCL,

3 7899

can i create trigger on synonym is it possible or not please help me

CGI,

4 11150

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

Infosys,

3 11803


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is join an inner join?

1019


What does pl sql developer do?

974


What is $$ in sql?

1042


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7475


Explain ddl statements in pl/sql?

1041


Write the command to remove all players named sachin from the players table.

1221


What is user defined functions?

1023


Why primary key is required?

1037


How to pipe multiline string to isql?

1047


What is cte?

1019


What is Histogram?

1606


Which join is like inner join?

1083


Show the two pl/sql cursor exceptions.

1251


What is error ora-12154: tns:could not resolve the connect identifier specified?

1117


What is database white box testing and black box testing?

1155