#1
  1. No Profile Picture
    almost there....
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    A Red Glitter Coffin
    Posts
    140
    Rep Power
    0

    Triggers on Nested Tables?


    Are triggers on nested tables possible?

    if so how do i do it?

    thanks!
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    New Delhi
    Posts
    3
    Rep Power
    0
    Yes you can do it as below:

    CREATE OR REPLACE TRIGGER trigger_name
    INSTEAD OF INSERT OR UPDATE
    ON NESTED TABLE nested_table_names OF parent_table_name
    BEGIN

    END;
    /

IMN logo majestic logo threadwatch logo seochat tools logo