Answer Posted / dinesh a.

create table x (col1 number(4));
insert into x value(1);
....
...
insert into x value(10); /* upto 10 rows

then

select
substr(max(decode(rownum,1,col1,0)),1,2),
substr(max(decode(rownum,2,col1,0)),1,2),
substr(max(decode(rownum,3,col1,0)),1,2),
substr(max(decode(rownum,4,col1,0)),1,2),
substr(max(decode(rownum,5,col1,0)),1,2),
substr(max(decode(rownum,6,col1,0)),1,2),
substr(max(decode(rownum,7,col1,0)),1,2),
substr(max(decode(rownum,8,col1,0)),1,2),
substr(max(decode(rownum,9,col1,0)),1,2),
substr(max(decode(rownum,10,col1,0)),1,2)
from x

(where substr only to reduce display size )

What is private procedure oracle?

1012

---

Write a trigger example in oracle?

1068

---

What privilege is needed for a user to query tables in another schema?

973

---

How to get a list of all background sessions in the database?

993

---

Explain the use of file option in exp command.

1131

---

What is the difference between count (*), count (expression), count (distinct expression)?

1011

---

How to write a query with a left outer join in oracle?

1065

---

How to create a stored function in oracle?

1108

---

How many types of cluster table in Oracle?

1034

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

---

How to get execution path reports on query statements?

989

---

How to run create database statement again?

1160

---

How oracle handles dead locks?

1066

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1019

---

Explain implicit cursor.

1036

---