Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Oracle SQL PLSQL Interview Questions
Questions Answers Views Company eMail

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 16029

Differences between UNIQUE and DISTINCT in select statements

26 127389

What are the attributes of SQL*PLUS ?

2 9164

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 18365

i want to display 1 to 10 numbers using one select statement.

18 42201

why use cursors?

5 10789

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 11569

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 15634

How can i insert data inro a table with 3 columns using FORALL?

2 9815

what is autonomouse transaction?

3 6889

what are pl/sql collections?

4 30358

How to create a view on a table which does not exists

4 19497

how to write utl file pkg in SQL

1 5592

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 18246

what is the difference difference between procedure and packages

2 9163

Post New Oracle SQL PLSQL Interview Questions


Oracle SQL PLSQL Interview Questions


Un-Answered Questions

What do you understand by copy constructor in java?

475


How to generate all permutations of a list in python?

476


What is the use of ioc?

178


How to select a transformer group to connect a 0,433 KV generation with 33 KV grid in bi directional flow of current

1099


what is clean sweep?

1859






How to enable cURL in PHP?

629


How do managerial economies affect the country?

1


why chock were used in old tubelights but are not newest tubelights?

1427


Explain the flow of creating a cube? : sql server analysis services, ssas

599


What are the benefits of ioc in spring?

164


What is HibernateTemplate class?

160


What are the difference between python and java?

465


How vugen create a vuser script?

622


What is icai?

674


When we are calculating the heat load sheets,why we are not considering the heat developed from the blood in the human body.Also both men & women can't acess aircondition in same way..women feel too cool even at 22 degree,while men can overcome that.

1438