1. Display all the rows and columns in the CLIENT table.
Sort by client name in reverse alphabetical order.
- 2 Answers
- 5604 Views
- Wipro, I also Faced
- E-Mail Answers
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
What is the difference between Delete, Truncate and Drop in Oracle?
How to insert a new row into a table in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
Why does for update in oracle 8 cause an ora-01002 error?
What is oracle database 10g express edition?
What are privileges and grants?
How to write a query with a right outer join in oracle?
What does sharding mean?
query optmization techniques and quwry analyser+projects+ppts
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Is it possible to insert comments into sql statements return in the data model editor ?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How do I escape a reserved word in oracle?
What do you mean by redo log file mirroring?
Why packages are used in oracle?
