Re: Making certain records in table non-deleteable

From: Pierre Viret <viretp_at_post.ch>
Date: 1 Sep 1999 10:34:40 GMT
Message-ID: <7qivg0$rru$1@wcwe00a6.post.ch>

Hello

An other solution would be to put theses records in a special table, so you have no mix between datas and control-structures.

Pierre

In article <37CB9B5C.7376AC2_at_pacbell.net>, tom-s_at_pacbell.net says...
>
>> I have a table which will contain many records; however, several records
>> in this table help to drive the PL/SQL and should never, ever be deleted
>> or altered. How can I make these records permanent? What is the best
>> way?
>
>Probably the easiest way is to use a trigger that cancels the delete if
>certain conditions are met.
>
Received on Wed Sep 01 1999 - 05:34:40 CDT