select * from emp order by ename desc

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

Question Posted / k amit gupta

Answer Posted / k amit gupta

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How can we find out the duplicate values in an oracle table?

1044

Difference between pre-select and pre-query

1106

What are a query and state the different types of queries and their uses?

1015

Can you create a synonym without having a table?

1041

How can you merge two tables in oracle?

1001

Write a trigger example in oracle?

1061

How to create a stored program unit?

1228

How to create an oracle database?

1041

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1932

How to use in conditions in oracle?

1058

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4520

What is merge in oracle?

1054

State any two functions of oracle?

1045

What is execute immediate in oracle?

1021

What is an oracle data file?

1103