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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

Zensar,

3 8255

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

Zensar,

1 5124

how can stop the sequence with mention the max value and with out mention the max value

Zensar,

1 6486

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

Zensar,

9 12417

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 8927

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

Hexaware,

4 10157

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

1 5237

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

IBM,

13 19838

What are different types of refreshment techniques of materialised view

2 8265

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 12497

What is the relation b/w view and trigger

Accenture, TCS,

3 16681

can i use global variables in stored procedure or function

L&T,

1 8317

what is the difference between stored procedure and packaged procedure

Google, Infosys,

1 11614

write a query that returns first characters of each word in Oracel/Sql pl sql

5 10106

In a table only one column how to update rows

Microsoft,

5 9915

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How many postgresql users are there, worldwide?

1125

What is the difference between partitioning and sharding?

1046

What are the types of variable use in pl sql?

1131

Is oracle sql free?

1035

Where not exists in sql?

1029

what is acid property in database? : Sql dba

1061

What is posting?

1081

How to pronounce postgresql?

1092

What are the benefits of pl sql?

1173

what is 'mysqlimport'? : Sql dba

1105

How do you optimize a query?

1055

Is sql developer case sensitive?

1043

What are different methods to trace the pl/sql code?

1164

When you have to use a default "rollback to" savepoint of plvlog?

1248

What is update query?

1028

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