triggername [message #10091] |
Mon, 05 January 2004 02:11 |
bhavin
Messages: 6 Registered: May 2003
|
Junior Member |
|
|
can triggername same with table name? and how many column we can put in one table?
bhavin
|
|
|
|
Re: triggername [message #10093 is a reply to message #10091] |
Mon, 05 January 2004 02:22 |
CheekuK
Messages: 14 Registered: December 2003
|
Junior Member |
|
|
Hi,
You can have the trigger name same as the table name because the name spaces for tables and triggers are same.
Upto 8i the max number of columns in a table can be 32. I am not aware of 9i.
Any doubts revert back.
Thanks and Regards
|
|
|
Re: triggername [message #10094 is a reply to message #10093] |
Mon, 05 January 2004 02:32 |
Daljit Singh
Messages: 290 Registered: October 2003 Location: Texas
|
Senior Member |
|
|
Hi,
I think u have mispelled it "You can have the trigger name same as the table name because the name spaces for tables and triggers are same", actually it should be "You can have the trigger name same as the table name because the name spaces for tables and triggers are not same".
And in oracle we can have upto 1000 columns in table.
I hope it will help u.
|
|
|
Re: triggername [message #10095 is a reply to message #10093] |
Mon, 05 January 2004 02:33 |
CheekuK
Messages: 14 Registered: December 2003
|
Junior Member |
|
|
oops m sorry for the Typo Mistake. Actually the name space for Tables and Triggers is NOT same. So you can have the same name trigger as the table.
|
|
|
Re: triggername [message #10096 is a reply to message #10093] |
Mon, 05 January 2004 03:00 |
|
Barbara Boehmer
Messages: 9090 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
There is a limit of 32 columns per index and 1000 columns per table, at least in 9i. Here is a link to the section of on-line documentation that sayas so:
|
|
|