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

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1460


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1483


What are the most common interview questions on ETL Testing for experience?

599


How to concatenate two text values in oracle?

593


How to insert multiple rows with one insert statement in oracle?

572






How to store pictures on to the database?

532


does the query needs a hint to access a materialized view?

1468


What are the database administrators utilities available?

580


Which is better Oracle or MS SQL? Why?

3980


What is Virtual Private Database in Oracle?

629


What is the usage of control file in oracle?

611


What's dateware house and what's clustor with practicle example

1643


How to use subqueries with the exists operator in oracle?

608


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1533


How will you write a query to get a 5th rank student from a table student_report?

1378