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 8130

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 5047

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

Zensar,

1 6389

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 12163

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 8731

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 10010

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

1 5156

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

IBM,

13 19379

What are different types of refreshment techniques of materialised view

2 8163

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 12240

What is the relation b/w view and trigger

Accenture, TCS,

3 16509

can i use global variables in stored procedure or function

L&T,

1 8241

what is the difference between stored procedure and packaged procedure

Google, Infosys,

1 11513

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

5 9925

In a table only one column how to update rows

Microsoft,

5 9757

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a constraint? Tell me about its various levels.

1157

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1105

What is sharding in sql?

969

Why do we create stored procedures & functions in pl/sql and how are they different?

940

Are null values same as that of zero or a blank space?

1022

How to run sql statements with oracle sql developer?

1059

how many tables will create when we create table, what are they? : Sql dba

1068

How to write pl sql program in mysql command prompt?

1089

How do you delete data from a table?

1023

What is schema in sql?

943

How do I create a memory optimized filegroup?

959

Is pl sql useful?

985

How to avoid using cursors?

1117

What is data types in sql?

1004

How to use distinct and count in sql query? Explain

1013

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