Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Validating that a field is Alpha
In article <8cd2lk$46u$1_at_nnrp1.deja.com>, joelsung_at_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
ADDRESS ZIPCODE VARCHAR2 10 PARAMETERS PARM VARCHAR2 10
HTH
--
Gorm Larsen
Received on Tue Apr 04 2000 - 17:00:45 CDT