Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: can I resolve with a trigger?

    Hi,
    I've this problem

    I've create a table AD
    ID1 ID2 ADMIN COD
    A A TOM 100
    A B SAM 200

    This table derives from this table COD

    ID1 ID2 COD FLAG
    A A 100 2
    A B 200 1

    if flag=2 admin=tom
    if flag=1 admin=sam

    In tab AD I must insert automatically new records.

    if I insert into COD this record:

    ID1 ID2 COD FLAG
    C C 300 2

    I'd like to see into tab AD this record:

    ID1 ID2 ADMIN COD
    C C TOM 300


    How can I create this trigger??

    Thanks
    Raf

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: can I resolve with a trigger?

    Yes, you can create a trigger to do that. Have you tried writing one yet?

    Here is Application Devbeloper's Guide:

    http://technet.oracle.com/docs/produ...g13trg.htm#376
    Last edited by andrewst; 04-01-03 at 12:24.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •