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!

How to find all records which contains only alphabets in a column?

617793Jan 15 2008 — edited Jan 16 2008

How to find all records which contains only alphabets, in a column which is VARCHAR2?

Column <ColumnX> in table <TABLE1> contains data like:
ABC123
ABC23456789
ABCDEFG
234567890
45654855
rewtyyyu

We need all rows which have column <ColumnX> in table <TABLE1> containing:
ABCDEFG
rewtyyyu

Thanks,

Amitabh

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2008

Added on Jan 15 2008

8 comments

6,830 views