SQL PLSQL Interview Questions
Questions Answers Views Company eMail

overloading of stored procedure is possible in oracle?

Nelco,

3 14502

What is meant by Join? What are the different types of Joins available? Explain.

Cap Gemini,

5 15231

How will you select unique values from a list of records?

Cap Gemini,

7 15248

How will you delete a particular row from a Table?

Cap Gemini,

7 13921

What is the difference between the Primary and Foreign key?

Cap Gemini,

7 14238

From an Employee table, how will you display the record which has a maximum salary?

Cap Gemini, Exilant, Synechron,

29 31957

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 5201

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

Satyam,

11 11972

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

Satyam,

8 9154

what is the cursor and use of cursor in pl/sql ?

4 5931

Can We write bulk collect statement in triggers?

Polaris,

1 8515

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 4120

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 6917

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

Tech Soft,

4 6853

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

Keane India Ltd,

5 8334


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How to return multiple rows from the stored procedure?

497


What are primary key and foreign key and how they work?

523


Are pl sql variables case sensitive?

565


What is a pragma statement?

692


Why stored procedure is better than query?

487






Which certification is best for sql?

510


Why is there a need for sqlcode and sqlerrm variables?

560


What does subquery mean in sql?

514


how to fetch common records from two tables? : Sql dba

601


What are expressions?

539


What is the command used to fetch first 5 characters of the string?

859


Why functions are used in sql?

492


What is the difference between a primary key and a unique key?

539


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

666


what is msql? : Sql dba

546