SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

How can u find column name from a table which have max value in a row.( not max value)

5 7699

Temporary table vs Table variable in sql server?

Wipro,

2393

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

Mind Tree, Polaris, Sonata,

10 16368

what is difference between pass by value and eference by value in oracle plsql

1 6347

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

CGI,

5 8388

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2023

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

TCS,

2555

what is the difference between pragma exception_init and raise_application_error

Aetins, State Street,

1 36565

What is difference between select statement and cursor

JDA,

3 21103

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

Cap Gemini, TCS,

6 19840

What are the steps you take to tune(performance tuning) the code in plsql?

Cap Gemini, Infosys, TCS,

4 18113

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 6850

why not null constraint showing its constraint type as 'c'

1 4650

What is the basic difference between a sql and stored procedure ?

L&T,

2 6820

Which is the best place to learn hadoop?

1 5314

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how can we destroy the session, how can we unset the variable of a session? : Sql dba

998

What does data normalization mean?

962

What is triggering circuit?

1064

What is lexical units in pl sql?

1146

What are inner and outer joins examples of both?

960

Can triggers stop a dml statement from executing on a table?

1096

Are sql connections encrypted?

1023

What is the clause we need to add in function body to return variable?

1012

Why is pl sql needed?

943

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1004

what happens if null values are involved in expressions? : Sql dba

1045

How is use pl and sql?

1061

What is an oracle stored procedure?

1051

Can one improve the performance of sql*loader? : aql loader

1048

How many types of index are there?

1040

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