Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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.


3 5018

ex: take one schema in that t1,t2, 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.


1 3301

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


1 4556

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...


9 7636

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

6 5371

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


4 7033

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

1 3811

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


13 12802

What are different types of refreshment techniques of materialised view

2 6176

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.....

7 6769

What is the relation b/w view and trigger

Accenture, TCS,

3 10202

can i use global variables in stored procedure or function


1 6223

what is the difference between stored procedure and packaged procedure

Google, Infosys,

1 7728

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

5 6727

In a table only one column how to update rows


5 6654

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is crud diagram?


What is forward declaration in pl sql?


what is subquery? : Sql dba


What is sqlcontext?


Can you select everything, but 1 or 2 fields, without writer's cramp?


What are analytic functions in sql?


How do you delete data from a table?


Does sqlite need a server?


Which table is left in join?


Explain select statements in sql?


how to dump a table to a file with 'mysqldump'? : Sql dba


What is pl/sql table? Why is it used?


Does a join table need a primary key?


Is full outer join same as cross join?


what is union, minus and interact commands? : Sql dba