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 6681

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 4160

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

Zensar,

1 5490

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 9945

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 6911

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 8566

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

1 4483

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

IBM,

13 15878

What are different types of refreshment techniques of materialised view

2 7145

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 9332

What is the relation b/w view and trigger

Accenture, TCS,

3 14608

can i use global variables in stored procedure or function

L&T,

1 7440

what is the difference between stored procedure and packaged procedure

Google, Infosys,

1 10252

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

5 8172

In a table only one column how to update rows

Microsoft,

5 8152


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What does joining a thread mean?

521


How do I run a program in pl sql?

472


What is difference between my sql and sql?

508


How does sql developer connect to oracle database?

501


How to make a copy values from one column to another in sql?

543






What are sql ddl commands?

514


Name the different types of indexes in sql and define them.

539


What are the parts of a sql statement?

527


how to escape special characters in sql statements? : Sql dba

489


how many groups of data types? : Sql dba

543


What is rollback?

556


How many functions are there in sql?

509


How can I change database name in sql?

500


Why do we use partitions in sql?

518


What are triggers and its uses?

568