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
5360 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

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers

What is a partition in oracle?

0 Answers

What is a data dictionary and how can it be created?

0 Answers

How many file formats are supported to export data?

0 Answers

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

0 Answers Oracle,

What is Partitions in Table ?

2 Answers Atiric Software,

How to delete multiple rows from a table in oracle?