OraFAQ Forum: Training & Certification » is it possible with same table name and trigger??

Home » Other » Training & Certification » is it possible with same table name and trigger??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

is it possible with same table name and trigger?? [message #332284]

Tue, 08 July 2008 01:49

joeslee
Messages: 18
Registered: February 2008
Location: Bangalore

Junior Member

A table can have same table name and trigger name???

Report message to a moderator

Re: is it possible with same table name and trigger?? [message #332306 is a reply to message #332284]

Tue, 08 July 2008 02:43

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would you believe me if I say "Yes, it can"? Or would you believe me if I say "No, it can not"? Which answer do you prefer? How much would it cost if you try and see for yourself? (I'll tell you - costs nothing and takes 2 minutes of typing).

Report message to a moderator

Re: is it possible with same table name and trigger?? [message #332309 is a reply to message #332284]

Tue, 08 July 2008 02:57

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> create table t (col number);

Table created.

SQL> create trigger t after insert on t begin null; end;
  2  /

Trigger created.

32" of typing and I made of typo I had to fix. Smile

Regards
Michel

[Updated on: Tue, 08 July 2008 02:58]

Report message to a moderator

Re: is it possible with same table name and trigger?? [message #332353 is a reply to message #332309]

Tue, 08 July 2008 05:07

Frank
Messages: 7901
Registered: March 2000

Senior Member

Michel Cadot wrote on Tue, 08 July 2008 09:57

32" of typing and I made of typo I had to fix. Smile

32" and unable to display more than 80 chars?!

Report message to a moderator

Re: is it possible with same table name and trigger?? [message #332362 is a reply to message #332353]

Tue, 08 July 2008 05:42

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Report message to a moderator

Previous Topic:	RDBMS Certification
Next Topic:	forms & reports interview questions..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 22:32:39 CST 2024