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 20302

Differences between UNIQUE and DISTINCT in select statements

26 136438

What are the attributes of SQL*PLUS ?

2 10580

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 22835

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

18 48234

why use cursors?

5 13030

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

8 14169

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 18660

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

2 10946

what is autonomouse transaction?

3 8334

what are pl/sql collections?

4 32280

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

4 21211

how to write utl file pkg in SQL

1 6644

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

4 19942

what is the difference difference between procedure and packages

2 10537

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

What are the challenges you face being in this industry and how do you overcome it?

589

Expand-------NSAC

1989

What do you understand by mpm in apache?

878

What is the purpose of vh measurement unit?

739

1. If 8.35%Z means the percentage impedance of 132kV-line from power company, we will like to confirm its base capacity?

2019

What is session and cookies in asp.net?

1054

How to get last row id?

1049

Does application messaging work between 8.1x and 8.4x applications?

876

Define data type and what are the types of data type?

946

What has happened in the markets in the past three months?

1027

What are the static and dynamic dashboards? Can dynamic dashboards be scheduled?

707

How do I insert columns in word?

630

Where is the find and replace in word?

705

What is difference between static and non-static fields of a class?

1162

How many types of sessions are there in asp net?

1044