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 6276

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 15226

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 11311

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

4 7635

Can We write bulk collect statement in triggers?

Polaris,

1 9273

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 7833

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 8336

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 9846

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Does sqlite need a server?

1042

What does (*) mean in sql?

945

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

5154

Name the operator which is used in the query for pattern matching?

939

Does pdo prevent sql injection?

927

What is difference between cursor and trigger?

1066

What is pl sql commands?

1043

What is orm in sql?

1041

What is pl sql code?

1045

State some properties of relational databases?

1049

What are the uses of merge?

1160

What is an index in sql with example?

969

What are the different operators available in sql?

999

How to return an array from java to pl/sql?

1127

what is collation? : Sql dba

1142

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