Re: Simple Interview Question...

On 11 Mar 2005 04:36:25 -0800, "Ariji Chatterjee" <arijitchatterjee123_at_yahoo.co.in> wrote:

>Dear Faculties,
>Is there any limitation that these many constraints in a particular
>table can exist.I tried but upto 2000.Please any body can tell me the
>exact answer.
>Regards
>Arijit Chatterjee
>

Hi Arjiit,

 If there's a limit, it is very, very high.

But why don't you just try it :

create table t1(c1 number(10));

declare
  limit number(38) := 1;
begin
  while 1 = 1 loop
    limit := limit + 1;
    execute immediate 'alter table t1 add constraint t1_ckh' || limit || ' check (c1 > '|| limit || ')';
  end loop;
end;
/

• Kenneth Koenraadt