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
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Explain the use of indexes option in imp command.
Calculate difference between 2 date / times in oracle sql?
What is bulk load in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What happens to indexes if you drop a table?
Which is better Oracle or MS SQL? Why?
How to turn on or off recycle bin for the instance?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to use group functions in the select clause using oracle?
What is the difference between pre-select and pre-query?
What is an oracle cursor variable?
What is the database name in oracle?
what is IDE,DMV in sql server?
Differentiate between translate and replace?