OraFAQ Forum: SQL & PL/SQL » interchage sql

Home » SQL & PL/SQL » SQL & PL/SQL » interchage sql

Mon, 23 April 2007 10:19

pavuluri
Messages: 247
Registered: January 2007

Senior Member

i have table


no
1
2
3
4
5
6
7

i want to output

6
5
4
3
2
1
7

Mon, 23 April 2007 10:30

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select no from tab
order by decode(no,7,0,no) desc;

Regards
Michel

Previous Topic:	DBMS_JOB Job not starting.
Next Topic:	Trigger problems

Goto Forum:

]

Current Time: Thu Dec 05 19:24:12 CST 2024