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

Polaris,

1 6339

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

CTS,

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...

iGate,

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

UST,

11 13004

why use cursors?

Oracle,

5 9177

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

Oracle,

8 9562

what is oracle sql,pl/sql with interfaces

TCS,

2 5829


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

What is set transaction?

184


Why is pl sql used?

158


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

199


What is the file extension for sql database?

140


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

135






what are properties of a transaction? : Sql dba

179


What is the use of primary key?

144


Which join is like inner join?

149


What is database white box testing and black box testing?

193


Why having clause is used in sql?

142


What is sqlite format?

150


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

315


What is cursor in pl sql?

149


what is uncommittable transactions? : Transact sql

168


Can we create table in function?

151