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 6302

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 15281

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 11356

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

4 7658

Can We write bulk collect statement in triggers?

Polaris,

1 9292

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 4851

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

2 7843

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 8363

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 9871

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is query syntax?

972

What does varchar include?

951

What is a dirty read sql?

1139

How delete all data from all tables in sql?

946

Mention what is the plv (pl/vision) package offers?

1107

What is Materialized View? In What Scenario we Use Materialized View?

9517

What is a sql*loader control file?

1266

Write an sql query to select all records from the table?

1030

what is data manipulation language? : Sql dba

1020

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1100

What are the different schemas objects that can be created using pl/sql?

1029

What is the purpose of normalization?

1040

Is left join inner or outer by default?

1019

Why is a trigger used?

943

how can we find the number of rows in a table using mysql? : Sql dba

1083

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