Re: HELP: Sequences and primary keys beginner question.

Ben,

It isn't really all that hard. Just write a perl program that generates that SQL to create your triggers. Store the table_name, column_name, and sequence_name in a text file for you program to read, and generate all of your triggers.

Just had to do this today in fact. It took about an hour. After that just maintain the text file, ora replace it to generate new triggers.

This could just as easily be done with a small database table and a SQL script to generate the trigger code.

Maybe not as slick as the database doing it for you, but it sure beats typing. ;)

On Tue, 24 Jun 1997 18:21:07 GMT, benh_at_dascom.com (Ben Harmon) wrote:

>
>
>Thanks Jared,
> I appreciate your response. However, as I mentioned in my post, I
>know how to write the trigger, but am wondering if there is an alternative.
>This process seems very labor intensive for the person who must write a
>script for every table, as well as incurring a fair amount of overhead.
>
>Thanks,
>Ben
>
>
>
Received on Thu Jun 26 1997 - 00:00:00 CDT