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
- 6543 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
How many types of database triggers exist?
What are the ansi data types supported in oracle?
What are dml statements in oracle?
Explain the use of Merge statement in oracle 11g
Please explain oracle data types with examples?
How to use like conditions in oracle?
What is literal?
How to invoke the data pump export utility?
Explain about your project and its relation to the current job position you are applying to?
Hi Can any one tell me what are the API's used in requisition import.
Why oracle is used?
What is the Tune Query
What are the differences between char and nchar in oracle?
How to export your own schema?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
