Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Making certain records in table non-deleteable

Re: Making certain records in table non-deleteable

From: Bob Fazio <bob_fazio_at_hotmail.com.no.spam>
Date: Wed, 01 Sep 1999 12:02:16 GMT
Message-ID: <cB8z3.2477$E46.3222@news.rdc1.pa.home.com>


Add a view, that does a union of the two tables, so you can see both from one place.
Pierre Viret <viretp_at_post.ch> wrote in message news:7qivg0$rru$1_at_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 - 07:02:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US