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 / eswar reddy
declare one cursor ,PL/SQL TABLE
IN DBMS MENTIONED PRIOR,LAST,FIRST
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do we get field detail of a table?
How to create a stored program unit?
What are the various constraints used in oracle?
master table and child table performances and comparisons in Oracle ?
What is a nested table and how is it different from a normal table?
Explain joins in oracle?
Why do we use bulk collect in oracle?
Explain the use of compress option in exp command.
What is meant by raw datatype?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is Redo Log Buffer in Oracle?
Why do you use stored procedures and state some of its disadvantages?
How can we delete duplicate rows in a table?
How to install oracle odbc drivers?
Why we use bulk collect in oracle?