1. Display all the rows and columns in the CLIENT table.
Sort by client name in reverse alphabetical order.

Answers were Sorted based on User's Feedback



1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetica..

Answer / k amit gupta

select * from emp order by ename desc

Is This Answer Correct ?    8 Yes 1 No

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetica..

Answer / yogesh sharma

select * from emp order by reverse(ename) ;

Is This Answer Correct ?    6 Yes 3 No

Post New Answer

More Oracle General Interview Questions

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers   IBM, Wipro,


What is a private synonym?

0 Answers  


I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,


wirte the syntax of update query?

3 Answers   IBM,


Explain integrity constraint?

0 Answers  


What is oracle and what are its different editions?

0 Answers  


Is there any function in oracle similar like group_concat of mysql?

0 Answers  


How to get execution path reports on query statements?

0 Answers  


what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,


How to establish administrator authentication to the server?

0 Answers  


hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,


Explain what are the type of synonyms?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)