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

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

Question Posted / deepakgunji

2 Answers
5808 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / k amit gupta

select * from emp order by ename desc

Is This Answer Correct ?

8 Yes

1 No

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

Answer / yogesh sharma

select * from emp order by reverse(ename) ;

Is This Answer Correct ?

6 Yes

3 No

Post New Answer

More Oracle General Interview Questions

How to Identify the previously inserted/updated records in already populated table.

0 Answers

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers HCL,

find out first highest salary?

10 Answers Verinon Technology Solutions,

Explain what does a control file contain?

0 Answers

What is instant client oracle?

0 Answers

difference between procedures and function?

7 Answers IBM,

How do I connect to oracle?

0 Answers

What do you mean by a deadlock?