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 )

How to retrieve data from an cursor to a record?

1153

---

What are the predefined tablespaces in a database?

1140

---

What are dml statements in oracle?

1130

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2394

---

Explain the use of tables option in exp command.

1166

---

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

1137

---

What are the numeric comparison operations?

1165

---

Explain table?

1174

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1123

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2295

---

Explain the difference between sap and oracle?

1082

---

Why does Oracle not permit the use of PCTUSED with indexes?

2478

---

How to change user password in oracle?

1092

---

How to run create database statement again?

1216

---

Difference between pre-select and pre-query

1173

---