Xref: alice comp.databases.oracle.misc:56701 Path: alice!news-feed.fnsi.net!cyclone.i1.net!newsfeed.enteract.com!hermes.visi.com!news-out.visi.com!newsfeedZ.netscum.dQ!netscum.int!news100.image.dk!news.worldonline.dk.POSTED!valhal.vestjyde.dk!anonymous From: Gorm Larsen Newsgroups: comp.databases.oracle.misc Subject: Re: Validating that a field is Alpha Lines: 29 Message-ID: References: <8cd2lk$46u$1@nnrp1.deja.com> Organization: Vestjyde X-Newsreader: MicroPlanet Gravity v2.20 Date: Tue, 04 Apr 2000 22:00:45 GMT X-Complaints-To: news-abuse@wol.dk X-Trace: news.worldonline.dk 954885645 212.54.90.250 (Wed, 05 Apr 2000 00:00:45 MET DST) NNTP-Posting-Date: Wed, 05 Apr 2000 00:00:45 MET DST In article <8cd2lk$46u$1@nnrp1.deja.com>, joelsung@my-deja.com says... > In PL/SQL, I need to validate that a field (VARCHAR2(1)) is Alpha. Is > there a quick, easy way to do this? Try: SQL> select table_name, column_name, data_type, data_length from user_tab_columns 2 where data_type = 'VARCHAR2' and data_length = 10 and rownum < 3; TABLE_NAME COLUMN_NAME ------------------------------ ------------------------------ DATA_TYPE ------------------------------------------------------------------------- ----------- DATA_LENGTH ----------- ADDRESS ZIPCODE VARCHAR2 10 PARAMETERS PARM VARCHAR2 10 HTH -- Gorm Larsen