Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help me about charactef function!!

Help me about charactef function!!

From: wajim <wajim29_at_hotmail.com>
Date: Tue, 31 Jul 2007 01:26:47 -0700
Message-ID: <1185870407.621316.210590@k79g2000hse.googlegroups.com>


Hi all,
I have a work on a table that I already created and populated with some values, numeric and non-numeric(alpha-numeric), the qustion is How can I sort all values from the column in numeric order?? This is the table I created:

SQL> select * from test_numb;

COLUMN_1



1
10
3
34
7
6
43
3-A
17-B
3-B

10 rows selected.

So it concerns the values 3-A, 17-B and 3-B I know there is a function ASCII(..) but don't see how to insert it in a select tatement;
Thanks in advance. Received on Tue Jul 31 2007 - 03:26:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US