Home » SQL & PL/SQL » SQL & PL/SQL » Create a trigger on a nested table
Create a trigger on a nested table [message #241656] Wed, 30 May 2007 05:50 Go to next message
Annee
Messages: 6
Registered: May 2007
Junior Member
Hi all.
I need to create a trigger on a nested table but I didn't know how to do it.
Can someone help me?

Thanks Very Happy
I'm using Oracle 10g
Re: Create a trigger on a nested table [message #241661 is a reply to message #241656] Wed, 30 May 2007 06:10 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member


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

END;



Check the oracle docs for more info
Re: Create a trigger on a nested table [message #241673 is a reply to message #241661] Wed, 30 May 2007 06:40 Go to previous messageGo to next message
Annee
Messages: 6
Registered: May 2007
Junior Member
for that, Do I need to create a view?
Re: Create a trigger on a nested table [message #241678 is a reply to message #241656] Wed, 30 May 2007 06:56 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't create a trigger on a nested table.

Regards
Michel
Previous Topic: archive log list - ORA-01031: insufficient privileges
Next Topic: Ora-04052 error plz help!!!
Goto Forum:
  


Current Time: Sun Dec 11 06:27:31 CST 2016

Total time taken to generate the page: 0.07708 seconds