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
- 6392 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 export your own schema?
How a database is related to tablespaces?
how may join possible between (requisition with purchase order)
Explain about the analyze command in oracle?
What is Library Cache in Oracle?
What is a data lock in oracle?
When do we use group by clause in a sql query?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Explain user account with reference to oracle.
Explain drop constraint oracle?
What is an Oracle Instance?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to write numeric literals in oracle?
What happens to the indexes if a table is recovered?
Can objects of the same schema reside in different tablespace?
