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

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 6952

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

Tech Mahindra,

4 6361

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

Ebix, Hewitt,

11 13089

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

HCL, Nyros, Oracle,

18 32390

how to debugg a procedure or package using dbms_output.put_line in plsql


1 6339

how can we find the select statement is indexed or not?


3 13115

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 5654

Please let me know if UNION ALL and Natural Join does the same operation and are same...


7 11082

With out using count() function. How to the find total number of rows in a table?

6 9296

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 4816

why should required for Indexed by table in pl/sql

3 5423

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used


11 13004

why use cursors?


5 9177

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


8 9562

what is oracle sql,pl/sql with interfaces


2 5829

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is set transaction?


Why is pl sql used?


How can you get sql*loader to commit only at the end of the load file? : aql loader


What is the file extension for sql database?


How can you tell the difference between an index and a view?


what are properties of a transaction? : Sql dba


What is the use of primary key?


Which join is like inner join?


What is database white box testing and black box testing?


Why having clause is used in sql?


What is sqlite format?


List and explain the different types of join clauses supported in ansi-standard sql?


What is cursor in pl sql?


what is uncommittable transactions? : Transact sql


Can we create table in function?