Re: Validating that a field is Alpha

From: Gorm Larsen <gorm_larsen_at_vestjyde.dk>
Date: Tue, 04 Apr 2000 22:00:45 GMT
Message-ID: <MPG.1354710e788d696c9896b4@valhal>

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

DATA_LENGTH

ADDRESS                        ZIPCODE
VARCHAR2
         10

PARAMETERS                     PARM
VARCHAR2
         10

HTH
--
Gorm Larsen Received on Tue Apr 04 2000 - 17:00:45 CDT