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 12727

Differences between UNIQUE and DISTINCT in select statements

26 118504

What are the attributes of SQL*PLUS ?

2 7937

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 14387

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

18 31068





why use cursors?

5 8849

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

8 9151

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 13021

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

2 8678

what is autonomouse transaction?

3 5714

what are pl/sql collections?

4 27564

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

4 16506

how to write utl file pkg in SQL

1 4677

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

4 16428

what is the difference difference between procedure and packages

2 7680

Post New Oracle SQL PLSQL Interview Questions




Oracle SQL PLSQL Interview Questions


Un-Answered Questions

why the pic micro controller have internal eeprom?But in 8051 have only rom and ram.

1947


Tell me what are the disclosures required in telemarketing? : insurance cold calling

48


Tell me what is applique?

1


List the type of locks?

102


Mention what is the difference between kernels, support packages & sap note?

7






can you explain about configuration files?

13


What is Comp-2?

127


What does socket consist of?

72


Clear property is available in ____,___ control.

623


Which property is used to add or subtract space between the letters that make up a word?

15


What is difference between static class and normal class?

66


Write code for the following in ASP a)Display attributes of a file b) File copy c) get disk capacity.

1105


How to change postgresql root user password?

100


what is an extended stored procedure? : Sql server database administration

74


whatis the commertial spec. of distribution boards ?

1070