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 19474

Differences between UNIQUE and DISTINCT in select statements

26 134765

What are the attributes of SQL*PLUS ?

2 10358

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 22060

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

18 47090

why use cursors?

5 12628

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

8 13694

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 18140

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

2 10744

what is autonomouse transaction?

3 8082

what are pl/sql collections?

4 31951

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

4 20865

how to write utl file pkg in SQL

1 6457

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

4 19663

what is the difference difference between procedure and packages

2 10279

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

What are the main features of ms excel?

541

wats the difference between RS latch using NAND n NOR gate? which is to be preffered?

2265

What is the use of limit() function in mongodb?

What's taking up space on my pc?

855

Is port 8000 a tcp or udp?

1083

What are distinct operators in impala?

What is fopl stand for and explain its role in artificial intelligence?

839

Some Realtime Objects on Bdc.

2858

Why unix is secure than windows?

928

Who is debtor purchaser

1904

What is the new version of qtp which is recently released in the market?

1037

How do I change the graph settings in excel?

637

What are the annotations used in hibernate?

387

How would you convince someone to follow your idea?

1079

How the warning lamp of a charging-system is activated ?

2582