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

Temporary table vs Table variable in sql server?

Wipro,

1898

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 13142

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

 1 5280

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 7012

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

 1556

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,

2066

what is the difference between pragma exception_init and raise_application_error

Aetins, State Street,

1 35191

What is difference between select statement and cursor

JDA,

3 19483

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 17741

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

Cap Gemini, Infosys, TCS,

4 16059

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

3 5724

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

 1 3903

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

L&T,

2 5557

Which is the best place to learn hadoop?

 1 4624

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is vs as in pl sql?

488

What does pl sql stand for?

653

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

549

Why is sql important?

577

What is the difference between partitioning and sharding?

523




What are the parameter modes supported by pl/sql?

532

What is the difference between the implicit and explicit cursors?

523

Can a foreign key be null?

586

What do we need to check in database testing?

554

What are types of exception?

532

How many postgresql users are there, worldwide?

578

what is commit? : Sql dba

615

Can you have a foreign key without a primary key?

507

Is a table valued function object?

577

How many types of normalization are there?

487

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