Follow Our FB Page << >> 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


Why we check moisture,ash & AIA in product


What is an iterative algorithm?


Explain logical operators in sql server?


Explain the difference between map and flatmap stream operation?


What are the different ways of Textile Quality Control?


What is socket file in linux?


How does hydraulics work?


What are different types of arrays?


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


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


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


Explain about processing table?


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


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.