Re: C.R.U.D. utilities

(Sorry 'bout the delay - ISP's newsgroup server acting up ... getting strange mixes of resend-old & delayed-new messages!)

I assume you already have the table defined and loaded into the dictionary. Then this is actually an easy one to program in SQL*Plus. Basically use the following steps:

1. create a sample for each of the 4 operations,
2. look at he DBA_ views to determine where you can get the appropriate info
3. create the mother of all SELECT statements that generates statements

Many of those on the list have been doing this for years ... simple, easy and cost effective. Ping me off list if you need more help

/Hans

Myron Murff wrote:

> PL/SQL, 9.2, Solaris 5.9
>
> Myron
> "Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message
> news:3EAED5FB.CAB46C8B_at_telusplanet.net...
> > Myron Murff wrote:
> >
> > > I need to generate several hundred insert, update, delete procedures for
> our
> > > current project. Can anyone recommend any utilities that automate the
> > > generation of these basic procedures?
> > >
> > > Thanks
> > > Myron
> >
> > Target host language? Target DB version? Target OS?
> >
Received on Thu May 08 2003 - 13:07:01 CDT