How to get constraint values?(m43)

Given a table definition like this

create table foo (
  a integer constraint bla check (between 1 and 5)
);

how is is possible to retrieve the 'constraint values' (here 1 and 5) ?
Is it possible to be done using OCI?


Ans:

Look in the system views USER_CONSTRAINTS or ALL_CONSTRAINTS
 
 

Hosted by www.Geocities.ws

1