Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> search_name = <<error>>
I created a table like:
create table abc
(
id VARCHAR(6),
cd integer,
)
I then went to add a constraint like:
alter table abc
add constraint ck_cd check (cd in ('Y','N'))
this was successful, but then I executed the command:
select * from all_constraints where TABLE_NAME='ABC'
and I see the constraint, but the search_condition is "<<ERROR>>".
What is up with that?
Mike Received on Thu Oct 07 2004 - 12:22:31 CDT