Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Making certain records in table non-deleteable
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
![]() |
![]() |