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
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?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the most common interview questions on ETL Testing for experience?
How to concatenate two text values in oracle?
How to insert multiple rows with one insert statement in oracle?
How to store pictures on to the database?
does the query needs a hint to access a materialized view?
What are the database administrators utilities available?
Which is better Oracle or MS SQL? Why?
What is Virtual Private Database in Oracle?
What is the usage of control file in oracle?
What's dateware house and what's clustor with practicle example
How to use subqueries with the exists operator in oracle?
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?
How will you write a query to get a 5th rank student from a table student_report?