Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query only non numeric values in a column

286079Jun 4 2002
How to query only non numeric values in a cloumn.
For example:
Table1 has a column1(col1)
Values:
Row Value
1 27376
2 47D99
3 83039
4 DKFI*
5 3J6

Query should retrieve only rows(2,4,5).

Thanks! for help
Murali
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2002
Added on Jun 4 2002
5 comments
1,441 views