order by

From: <meurer_at_swms.de>
Date: Tue, 16 Apr 2002 11:51:16 +0200
Message-ID: <a9gs6j$gju$02$1@news.t-online.com>

Hello,

I have an ordering problem. I wish to order the strings in the table 'tab_test' as an incremented statement. But the problem is that oracle can't recognize that the number '10' as a number.

this is the table

SVRMGR> select * from tab_test;
COL_A

---

A1
A3
A10
A2
..

and I wish to have this table or view with a SQL statement without define variables using PL/SQL or ordered by sysdate.

COL_A

---

A1
A2
A3
..

A10

Any ideas? I didn't find any order SQL statement to show the table as above... Thanks for reply Received on Tue Apr 16 2002 - 04:51:16 CDT