Oracle SQL PLSQL Interview Questions Answers, Oracle Placement Papers, Oracle Technical, HR Interview Questions, Oracle Aptitude Test Questions, Oracle Campus Placements Exam Questions

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 19911

Differences between UNIQUE and DISTINCT in select statements

26 135669

What are the attributes of SQL*PLUS ?

2 10468

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 22482

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

18 47663

why use cursors?

5 12846

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

8 13923

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 18426

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

2 10852

what is autonomouse transaction?

3 8228

what are pl/sql collections?

4 32130

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

4 21060

how to write utl file pkg in SQL

1 6558

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

4 19813

what is the difference difference between procedure and packages

2 10407

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

Can main() method in java can return any data?

1186

What is functional and regression testing?

1100

What is bare-metal node and what does it comprised of?

385

Burn two ropes, one needs 60 minutes of time to burn and the other needs 30 minutes of time. How will you achieve this in 45 minutes of time ?

338

What Is Mechatronics?

1024

Why you are selected software testing as career ?

1377

Is it possible for something to explode in space like in the movies?

1016

How generating electric power export to grid from the generating station ?

1879

Where do you use sampling procedures?

903

What is fulltrust?

1032

How do I print full page without margins?

352

What is difference between temp table and cte?

1019

What is the strategy used to test new mobile app?

1013

WHAT IS counter flux IN CT?

1949

What is the most common sql injection tool?

1041