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
Explain the use of ignore option in imp command.
What privilege is needed for a user to connect to oracle server?
Explain the use of online redo log files in oracle.
Explain oracle 12c new features for developers?
What is control file used for?
How to save query output to a local file?
What is an oracle tablespace?
How many file formats are supported to export data?
Explain the use of rows option in imp command.
What is a sub query? Describe its types?
How to resolve name conflicts between variables and columns?
What are the different types of database objects?
what is the use of system.effective.date variable in oracle?
How to do a full database export?
What are transaction isolation levels supported by oracle?