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
- 6683 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
How to add a new column to an existing table in oracle?
How to upsert (update or insert into a table)?
Differentiate between translate and replace?
How can we find out the current date and time in oracle?
How can you use check constraints for self referential integrity?
Explain an exception and its types?
What is the max number of columns in an oracle table?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Explain the use of grant option in exp command.
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to get a list of all background sessions in the database?
How do I find my oracle client driver version?
What is the data type of dual table?
What to do if the binary spfile is wrong for the default instance?
Can the query output be sorted by multiple columns in oracle?
