Follow Our FB Page << CircleMedia.in >> 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.

Zensar,

3 5018

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 3301

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

Zensar,

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

Zensar,

9 7636

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

Hexaware,

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

IBM,

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

L&T,

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

Microsoft,

5 6654


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

What is crud diagram?

117


What is forward declaration in pl sql?

145


what is subquery? : Sql dba

154


What is sqlcontext?

109


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

134






What are analytic functions in sql?

114


How do you delete data from a table?

108


Does sqlite need a server?

102


Which table is left in join?

117


Explain select statements in sql?

168


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

141


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

152


Does a join table need a primary key?

105


Is full outer join same as cross join?

97


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

165