Re: Check contsraint problem

 In article <carold-261095121306_at_carold-mac.logica.co.uk>, carold_at_lna.logica.com (Carol Dionne) writes:
> I'm new to Oracle (I'm more comfortable with Sybase) and can't determine
> how to do the following from the Oracle manuals. Any suggestions?
>
> I like to create a check constraint on an column of type char to test that
> the assigned value is restricted to the characters of 0-9,A-F. I'm using
> Oracle
> 7.1.6.2.
>
> In Sybase I would use a like clause with the pattern
> "[0-9,A-F][0-9,A-F][0-9,A-D][0-9,A-F]". My Oracle documentation doesn't
> mention
> any support of the [] symbols for testing a single character to be within
> a specified range. I've looked at all supplied functions and didn't see
> one
> that would help.
>
> Any suggestions on how to write this check constraint?

Carol,

You may try to use the TRANSLATE and RPAD functions. Try something like:

if translate(char_value, '0123456789ABCDEF', 'XXXXXXXXXXXXXXXX')

• rpad('X',length(char_value), 'X') then
  • char value is OK else
  • char value is NOT OK!!!! end if;

-- 
------------------------------------------------------------------------------
Pierre Hollard                                 
Oracle Database Administrator                  Phone: (404) 827-0656
Turner Broadcasting System, Inc.              E-Mail: phollard_at_dev1.turner.com
------------------------------------------------------------------------------