Re: PL/SQL
From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/03/28
Message-ID: <8bpkn7$f6e$1_at_perki.connect.com.au>#1/1
Date: 2000/03/28
Message-ID: <8bpkn7$f6e$1_at_perki.connect.com.au>#1/1
The table(view) which you need to look at is All_constraints This will cover primary key not null etc. You need to Query this table and reproduce the scripts. Tom
TDavison <INVALID_at_PCOM.NET> wrote in message
news:38e00667$1_at_news.pcom.net...
> I'm new to Oracle programming and I am trying to write a PL/SQL script
that
> when run will query the data dictionary tables and will re-create the
script
> that created and applied the constraints to the table in the first place.
> Does anyone have any sample code of how they did such a thing?
>
>
Received on Tue Mar 28 2000 - 00:00:00 CEST