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

    Unanswered: create a new table

    Hi,
    I've one table of more 200000 records with these columns:
    CODE NUMBER PRIMARY KEY
    AREA NUMBER
    USER VARCHAR2(15)

    the column AREA change often, cause I'd like to see this change in other table
    for example:
    CODE
    AREA_OLD
    AREA_NEW
    DIFFERENCE_AREA

    How can I create these values in this table automatically?

    Thanks
    Raf

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    you can create a trigger on your table, that inserts the values automatically into the second table when they are inserted or updated in the table.

    Look in the Oracle documentation on how to create triggers.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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