create table test (case varchar2(10));
Table created.
insert intotestvalues('a');
insert intotestvalues('B');
insert intotestvalues('c'); insert intotestvalues('D'); insert intotestvalues('E'); insert intotestvalues('D'); insert intotestvalues('D');
select * fromtest
CASE
D
f
a
B
c
D
E
D
f
select * fromtest order bycase
CASE
B
D
D
D
E
a
c
f
f
select * from test order by order by nlssort(case,'NLS_SORT= BINARY_CI');
CASE ---------- a B c D D D E f f 9 rows selected
No comments:
Post a Comment