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

Answer Posted / k amit gupta

select * from emp order by ename desc

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to import one table back from a dump file?

684


How to calculate date and time differences in oracle?

626


How to retrieve values from data fields in record variables?

656


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

592


What is the usage of analyze command in oracle?

701






How to create an initialization parameter file?

622


What are joins, explain all types of joins?

1819


How to start instance with a minimal initialization parameter file?

617


What is the purpose of save points in oracle database?

624


query optmization techniques and quwry analyser+projects+ppts

2058


IS it possible to built the oracle database without setting the kernal parameters?

1851


How oracle handles dead locks?

690


Explain the use of online redo log files in oracle.

670


What is a trigger oracle?

660


What is a user role in oracle?

701