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 19907

Differences between UNIQUE and DISTINCT in select statements

26 135656

What are the attributes of SQL*PLUS ?

2 10468

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 22479

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

18 47647

why use cursors?

5 12843

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

8 13917

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 18424

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

2 10848

what is autonomouse transaction?

3 8225

what are pl/sql collections?

4 32128

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

4 21051

how to write utl file pkg in SQL

1 6556

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

4 19808

what is the difference difference between procedure and packages

2 10406

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

how do secured fields behave for filtered views?

664

what are the functions of the typical server program? : Client server computing

979

What is meta html?

881

Please write a program to display “welcome to bestinterviewquestion.com” in c#?

918

If we want to copy 10 blocks from one machine to another, but another machine can copy only 8.5 blocks, can the blocks be broken at the time of replication?

665

What is the difference between action support and action function?

522

What is the ideal position cooling fan inside the dc motor?

2090

viewing entire results after the batch run in qtp Is there is a easier way view the complete results with out opening one by one test scripts

1974

plz send me hsbs finance questions asked in the interview ans appitude also

2879

What is test metric is software testing and what information does it contains?

1081

what does it mean an active front end in vfd plz explain it briefly

1876

What is eapol authentication?

982

What are the ways to use namespaces?

970

Explain the difference between a simulator and emulator.

1222

When the server gets shut down does data stored in memcached is still available?