Re: How to create a database trigger

On Mon, 08 Jan 2001 14:17:37 GMT, Inna <mednyk_at_my-deja.com> wrote:

>
>
>Hello everyone.
>Started creating database triggers and realized that know nothing about
>it. Please help me in this problem. I have two tables dept and emp.
>Have primary key ID in emp table and empid in dept, but I can not make
>it foreign. So I need a trigger <Before delete> on table emp, which
>going to delete record in dept table. And I don't know how to do that,
>because my books are not so good, there is no syntax there.
>Thank you in advance.

Here is a way to search the Oracle docs and get the results arranged based on the level of detail you want:

http://tahiti.oracle.com/pls/tahiti/tahiti.drilldown?word=trigger&book=&preference=&vbook=1

If you're not familiar with triggers at all, you can check out the introductory topics from Concepts. Once you know a little, you can see what the posibilities are (tasks). And you can find code examples to answer most questions.

John Received on Sat Jan 20 2001 - 16:48:35 CST