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 oracle data type?

942

---

What is the difference between a primary key & a unique key?

1071

---

How to calculate date and time differences in oracle?

1021

---

How to write numeric literals in oracle?

1164

---

Explain the characteristics of oracle dba?

1104

---

What are nested tables?

1151

---

How to run the anonymous block again?

1111

---

What is the use of oracle?

1020

---

Explain the difference between replace() and translate() functions in oracle?

1021

---

How can I create database in oracle?

996

---

What is a subquery?

1103

---

What are the attributes that are found in a cursor?

1045

---

What is instant client oracle?

1011

---

What is a read write transaction in oracle?

1064

---

How to load data through external tables?

1120

---