Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 13619

Differences between UNIQUE and DISTINCT in select statements

26 121295

What are the attributes of SQL*PLUS ?

2 8360

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 15451

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

18 33716





why use cursors?

5 9375

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

8 9857

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 13761

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

2 8989

what is autonomouse transaction?

3 6069

what are pl/sql collections?

4 28319

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

4 17213

how to write utl file pkg in SQL

1 4952

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

4 16957

what is the difference difference between procedure and packages

2 8217

Post New Oracle SQL PLSQL Interview Questions




Oracle SQL PLSQL Interview Questions


Un-Answered Questions

Compare the contents of the NetSim routing table with those of a IP/RIP based router

1815


Why we check moisture,ash & AIA in product

976


What is an iterative algorithm?

211


Explain logical operators in sql server?

244


Explain the difference between map and flatmap stream operation?

391






What are the different ways of Textile Quality Control?

1


What is socket file in linux?

192


How does hydraulics work?

266


What are different types of arrays?

191


Explain a MSIL ? Why is it appreciated by all developers?

272


Explain the difference between sap r/2 and r/3?

201


What automation tools could be used for post-release validation with continuous integration?

196


Explain about processing table?

163


what is the difference between dynamic as well as non - dynamic data structures.

244


stripos — Find position of first occurrence of a case- insensitive string int stripos ( char* haystack, char* needle, int offset ) Returns the numeric position of the first occurrence of needle in the haystack string. Note that the needle may be a string of one or more characters. If needle is not found, stripos() will return -1. The function should not make use of any C library function calls.

1452