Home » Other » Training & Certification » is it possible with same table name and trigger??
is it possible with same table name and trigger?? [message #332284] Tue, 08 July 2008 01:49 Go to next message
joeslee
Messages: 18
Registered: February 2008
Location: Bangalore
Junior Member

A table can have same table name and trigger name???
Re: is it possible with same table name and trigger?? [message #332306 is a reply to message #332284] Tue, 08 July 2008 02:43 Go to previous messageGo to next message
Littlefoot
Messages: 19770
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).
Re: is it possible with same table name and trigger?? [message #332309 is a reply to message #332284] Tue, 08 July 2008 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
Frank
Messages: 7880
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?!
Re: is it possible with same table name and trigger?? [message #332362 is a reply to message #332353] Tue, 08 July 2008 05:42 Go to previous message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Laughing

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


Current Time: Sun Nov 23 22:16:04 CST 2014

Total time taken to generate the page: 0.08251 seconds