1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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 10565

How to find only %th Highest Sal

Infogain, Symphony,

6 10024

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

Metric Stream,

2 8817

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

CTS,

2 9609

What are the Diff B/W Cursor and REF Cursor

CTS,

3 11724

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

Doyensys,

4 13595

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 17115

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

 3 7771

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 4036

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 8384

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 3140

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

when normalization is required

HCL,

3 6608

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

CGI,

4 9394

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 10353

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I turn a list into a table?

500

What are the basic techniques of indexing?

563

Which command is used to delete a trigger?

760

Which table is left in left join?

507

Which version of sql do I have?

551




Explain what is an index?

577

What is sql basics?

567

Explain scalar functions in sql?

569

What is the limitation on the block size of pl/sql?

520

Can a table have no primary key?

545

How to rename a table?

541

What is trigger explain with example?

540

Can we use ddl commands in pl sql?

549

List the different type of joins?

564

What is a database event trigger?

579

For More Un-Answered { SQL PLSQL } Questions Click Here