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

Answer Posted / yogesh sharma

select * from emp order by reverse(ename) ;

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to lock and unlock a user account in oracle?

618


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1527


Can select statements be used on views in oracle?

596


How to commit the current transaction in oracle?

578


Explain user account with reference to oracle.

540






How to find out what oracle odbc drivers are installed?

578


Explain about functional dependency and its relation with table design?

556


Why is oracle so popular?

561


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1927


Can you assign multiple query result rows to a variable?

552


What is index in Oracle?

594


What is Reduced List of Values?

1708


How to delete an existing row from a table in oracle?

645


How to convert character types to numeric types?

578


How to install oracle database 10g xe?

566