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 17929

Differences between UNIQUE and DISTINCT in select statements

26 131217

What are the attributes of SQL*PLUS ?

2 9826

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 20579

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

18 45086

why use cursors?

5 11838

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

8 12731

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 17058

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

2 10379

what is autonomouse transaction?

3 7558

what are pl/sql collections?

4 31272

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

4 20259

how to write utl file pkg in SQL

1 6002

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

4 19054

what is the difference difference between procedure and packages

2 9721

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

What is Gd PHP?

760

Explain what is polymorphism in c++?

874

What is a nested type. Give an example?

832

int i=10; printf("%d %d %d", i, i=20, i);

1304

Is excel rand truly random?

422

why various test are performed on electrical panels & power cables before commissioning on site & what are these test???

1758

What is the difference between cursor stability and repeatable read isolation levels?

923

What is standard data type and what is user defined data type?

2066

Is http stateful or stateless?

779

What is meant by biotransformation and swertiamarin?

2125

How do I change the name of master / parent role keeping the name of derived/child role same? I would like to keep the name of derived /child role same and also the profile associated with the child roles.

1137

What are the modes that are provided in silverlight?

Explain sovereign wealth fund.

848

Explain the difference between component, helper, behavior in cakephp?

What is the difference between left and left outer join?

727