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

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 6288

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 15266

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 11346

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

4 7651

Can We write bulk collect statement in triggers?

Polaris,

1 9285

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 4849

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

2 7841

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 8359

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 9869

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is int identity in sql?

1140

Difference between truncate, delete and drop commands?

1082

Why sql query is slow?

997

What is a subquery in sql?

1039

What is the largest value that can be stored in a byte data field?

1012

How do I run a pl sql procedure in sql developer?

968

what is the difference between a having clause and a where clause? : Sql dba

1087

Can we use view in stored procedure?

900

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2014

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1190

Could you please provide oca (oracle 10g) dumps for my certification ?

5166

How can use stored procedures in sql?

1136

How does index help in query performance?

1028

differentiate between float and double. : Sql dba

1056

How do you update sql?

970

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