Re: PLSQL for ddl

From: Charlie Mengler <charliem_at_mwh.com>
Date: Fri, 08 Dec 2000 08:18:19 -0800
Message-Id: <10704.124041@fatcity.com>

The resident list goddess, Rachel Carmichael, & co-author Kevin Looney have already provided this code and MORE!

Just buy the book "SQL & PL/SQL Annotated Archives"; ISBN 0-07-882536-9 and it comes with a CD so you'll be spared the typing & data entry errors.

HTH & HAND! David Turner wrote:
>
> I am writing several different procedures in plsql to help me drop and recreate
> all the constraints, foreign keys, indexes, grants, privileges associated with a given
> table so I can automate many of the mundane tasks I would like to avoid. Has anyone else
> done this and is willing to send me the code or list an html page where I can get them?
>
> Also has anyone done this in sqlj and is it even possible? I have hesitated working with sqlj
> because I thought much of the ddl I perform can only be done with plsql.
>
> Thanks, Dave Turner
Received on Fri Dec 08 2000 - 10:18:19 CST