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 19424

Differences between UNIQUE and DISTINCT in select statements

26 134636

What are the attributes of SQL*PLUS ?

2 10340

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 22017

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

18 47022

why use cursors?

5 12602

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

8 13665

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 18095

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

2 10730

what is autonomouse transaction?

3 8066

what are pl/sql collections?

4 31934

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

4 20852

how to write utl file pkg in SQL

1 6443

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

4 19641

what is the difference difference between procedure and packages

2 10260

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

Which is the smallest marsupial?

984

I need level 2 to 5 sas using companies in india

2332

What is a provider in angular?

762

What are the functionalities provided by the soap protocol class?

891

How to convert character types to numeric types?

1056

How to select all records from the table?

1071

Explain the advantages of asp.net.

948

Explain can you implement data mining in ssrs?

145

What is the use of jsp and servlet?

857

what happening if we casting HV shunt reactor foundation pad at 50cm height different time (One day difference)

1759

What is ADDM Advisor in Oracle?

1118

What is cluster in Cassandra?

What does stand for EPD,MIS? Can anyone tell me briefly n clearly about this?

2269

What is the limitation for radial immuno diffusion method?

398

What is meant by markup language?

739