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 19393

Differences between UNIQUE and DISTINCT in select statements

26 134587

What are the attributes of SQL*PLUS ?

2 10328

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 21976

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

18 46974

why use cursors?

5 12593

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

8 13648

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 18072

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

2 10722

what is autonomouse transaction?

3 8055

what are pl/sql collections?

4 31926

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

4 20838

how to write utl file pkg in SQL

1 6436

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

4 19626

what is the difference difference between procedure and packages

2 10250

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

What are the provisions to protect the interest of small depositors?

943

How to refresh an asp page on a single click of a button?

855

If you win a $10 million lottery, will you still work?

1203

How is Azure Resource Manager beneficial over the classic services?

500

How many modules are there in spring framework and what are they?

363

In how many ways we can do synchronization in java?

916

Can you select direct fi posting for a depreciation run? : fi- asset accounting

1017

How many elements are there in 3d-series of first transition series?

1022

What are the contrasts between a Power BI Dataset, a Report, and a Dashboard?

How to Block/ Un-Block GL Account?

1758

What is the use of a pseudo class?

605

Explain datetime2 data type in sal server 2008?

856

What are the benefits of cloud computing?

673

how cani do requirement testing using some testcase

2170

List any four practical values of teaching Mathematics.

1278