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 10555

How to find only %th Highest Sal

Infogain, Symphony,

6 10018

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

Metric Stream,

2 8815

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

CTS,

2 9601

What are the Diff B/W Cursor and REF Cursor

CTS,

3 11721

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

Doyensys,

4 13584

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 17106

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

 3 7769

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 4029

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 8378

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 3137

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

when normalization is required

HCL,

3 6607

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

CGI,

4 9376

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 10347

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

explain the advantages and disadvantages of stored procedure? : Sql dba

524

How can we solve sql error: ora-00904: invalid identifier?

685

how to include comments in sql statements? : Sql dba

531

What does the argument [or replace] do?

564

Why are sql stored procedures used?

603




Does oracle roll back the transaction on an error?

524

Is left join faster than inner join?

599

How do you optimize a query?

524

Can you select everything, but 1 or 2 fields, without writer's cramp?

486

What is a boolean in sql?

511

How to raise user-defined exception with custom sqlerrm ?

669

What is a behavioral trigger?

503

What is sql table?

513

what are the security recommendations while using mysql? : Sql dba

562

Explain the order of sql statement execution?

599

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