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
- 6547 Views
- I also Faced
- E-Mail Answers
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
Explain do view contain data?
Explain the dml?
What is the difference between PFILE and SPFILE in Oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to connect ms access to oracle servers?
What are the ansi data types supported in oracle?
How to use null as conditions in oracle?
What is a nested table and how is it different from a normal table?
How many data types are supported?
What privilege is needed for a user to create indexes in oracle?
Explain what are the uses of rollback segment?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is query image?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to define a record variable to store a table row?
