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 6389

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 15607

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 11583

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

4 7824

Can We write bulk collect statement in triggers?

Polaris,

1 9362

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 4911

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

2 7925

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 8541

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 10024

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I run a pl sql program?

1189

What are all the different types of indexes?

1195

What is a sql select statement?

1082

Can a foreign key be a duplicate?

958

What is a pragma statement?

1332

What is right join in sql?

1152

Compare sql & pl/sql

1209

Why do we use procedures?

1005

Can we use loop in sql?

1010

what is foreign key? : Sql dba

1105

What is materialized view in sql?

957

How to make a copy values from one column to another in sql?

1078

How do you change a value in sql?

1064

How many types of relationship are there?

1080

Is sql a backend?

1070

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