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 8490

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

Tech Mahindra,

4 8048

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 15670

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

HCL, Nyros, Oracle,

18 42207

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

Polaris,

1 7040

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

CTS,

3 15737

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

5 6911

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

iGate,

7 12685

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

6 10987

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 5609

why should required for Indexed by table in pl/sql

3 6478

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 15628

why use cursors?

Oracle,

5 10789

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

Oracle,

8 11573

what is oracle sql,pl/sql with interfaces

TCS,

2 7107


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I enable sql encryption?

496


Explain spool.

652


How to select all records from the table?

583


Is full outer join same as cross join?

474


What packages(if any) has oracle provided for use by developers?

4974






How many developers work on postgresql?

541


Which sql most popular?

524


What do you mean by table in sql?

503


what is heap table? : Sql dba

582


What is memory optimized table?

550


Can we perform dml on view?

530


What are the different tcl commands in sql?

591


What is the difference between sum and count in sql?

497


Can sql developer connect to db2?

561


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3086