Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 6679 Views
- I also Faced
- E-Mail Answers
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
Difference between open_form and call_form in oracle.
Explain the dml?
What is memory advisor in Oracle?
How to define a data source name (dsn) in odbc manager?
What happens if the update subquery returns multiple rows?
What is blob data type in oracle?
How would you change old and new values in an insert, delete and update triggers?
What are the limitations oracle database 10g xe?
What exactly do quotation marks around the table name do?
How to invoke the original export import utilities?
How many types of auditing in Oracle?
What is a tns service name?
What is the difference between pre-select and pre-query?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How do you find current date and time in oracle?
