1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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 8583

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

Tech Mahindra,

4 8114

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 15808

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

HCL, Nyros, Oracle,

18 42473

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

Polaris,

1 7081

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

CTS,

3 15817

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

 5 6990

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

iGate,

7 12785

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

 6 11089

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 5652

why should required for Indexed by table in pl/sql

 3 6534

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 15806

why use cursors?

Oracle,

5 10875

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

Oracle,

8 11685

what is oracle sql,pl/sql with interfaces

TCS,

2 7181

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is schema in sql example?

595

How do I run a sql query?

528

What is sql resultset?

527

Is left join inner or outer by default?

521

What are the uses of merge?

717




What are tuples in sql?

561

what is the difference between clustered and non clustered index in sql? : Sql dba

547

How do you break a loop in pl sql?

519

what are the advantages and disadvantages of cascading style sheets? : Sql dba

547

What is prepared statement in sql?

543

What is cursor in pl sql with examples?

479

what is “go” in t-sql? : Transact sql

598

What is rank dense_rank and partition in sql?

535

What are all the different normalizations?

587

What is sqlcontext?

549

For More Un-Answered { SQL PLSQL } Questions Click Here