I have a table emp. There is only one column in the table.
In that , there are only three rows in that column.
The value in the first row is 'A' and the value in the
second row is 'B' and the third row is 'C'. Now, my question
is ,
How will you write a select query to display the output as
B
C
A
Note: order by cannot be used coz it gives us output as CBA.
But the output should be BCA.
Answer Posted / ajitnayak
declare
type samp_type is table of VARCHAR2(20)
index by binary_integer;
table_type samp_type;
cursor c1 is
select Colum-Name from Table_name;
begin
open c1;
fetch c1 bulk collect into table_type;
close c1;
for i in reverse 1..4 loop
dbms_output.put_line(table_type(i));
end loop;
end;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is memory advisor in Oracle?
Explain an exception?
Explain integrity constraints?
 What are the oracle DML commands possible through an update strategy?
what is the dual table in oracle?
How to call a stored function in oracle?
Explain the use of file option in exp command.
How to use "if" statements on multiple conditions?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to write text literals in oracle?
Give the various exception types.
What is user managed backup in Oracle?
What are the oracle differences between nvl and coalesce
What is the sid in oracle?
What are advantages of dateset in datastage?