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 8259

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 5125

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

Zensar,

1 6492

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 12430

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 8930

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 10158

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

1 5239

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

IBM,

13 19846

What are different types of refreshment techniques of materialised view

2 8269

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 12507

What is the relation b/w view and trigger

Accenture, TCS,

3 16690

can i use global variables in stored procedure or function

L&T,

1 8319

what is the difference between stored procedure and packaged procedure

Google, Infosys,

1 11618

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

5 10116

In a table only one column how to update rows

Microsoft,

5 9923

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How to start the command-line sql*plus?

1103

Can I call a procedure inside a function?

1074

What is dcl in sql?

1024

What is a dynamic query?

1069

what are all the different types of indexes? : Sql dba

1103

What are secondary keys?

1030

What is a column in a table?

1185

What is pl sql architecture?

999

Is record in pl sql?

1011

How many postgresql users are there, worldwide?

1128

How to use boolean type in select statement?

1135

What is an exception in pl/sql?

1161

What is primary key and unique key?

1162

What is pl sql collection?

1014

Can we use ddl statements in stored procedure?

1190

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