Home » SQL & PL/SQL » SQL & PL/SQL » Maximum No. of columns and Triggers in Oracle
Maximum No. of columns and Triggers in Oracle [message #204320] Mon, 20 November 2006 02:48 Go to next message
send2aarti
Messages: 2
Registered: November 2006
Junior Member
Hi All,

Can somebody please provide me with this Info ?

1. Maximum No. of Triggers we can create on a table ?
2. Maximum No. of Columns a table can have in Oracle ?

Thanks,
Art
Re: Maximum No. of columns and Triggers in Oracle [message #204321 is a reply to message #204320] Mon, 20 November 2006 02:53 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi aarti



1. Maximum No. of Triggers we can create on a table ?
http://www.oreilly.com/catalog/ordevworkbook/chapter/ch16s.html



2. Maximum No. of Columns a table can have in Oracle ?
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/limits003.htm


hope this helps
Taj.
Re: Maximum No. of columns and Triggers in Oracle [message #204325 is a reply to message #204320] Mon, 20 November 2006 03:04 Go to previous messageGo to next message
send2aarti
Messages: 2
Registered: November 2006
Junior Member
Thanks a lot Taj for such a prompt reply !

Appreciated Smile
Re: Maximum No. of columns and Triggers in Oracle [message #204327 is a reply to message #204325] Mon, 20 November 2006 03:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You're welcome.
Re: Maximum No. of columns and Triggers in Oracle [message #204343 is a reply to message #204320] Mon, 20 November 2006 04:11 Go to previous messageGo to next message
dawood
Messages: 5
Registered: November 2006
Junior Member
13 database trigger is been used including instead of trigger.
Re: Maximum No. of columns and Triggers in Oracle [message #204369 is a reply to message #204320] Mon, 20 November 2006 06:09 Go to previous message
moparthy99
Messages: 13
Registered: July 2006
Junior Member
No of columns in 7.x is 254 .now from oracle 8i onwords 1000 cols.
For triggers for one table basically 12 ways we can write.But no,limit for triggers .
Previous Topic: Table Partition
Next Topic: UTL_MAIL.send: How to put RECORD in MESSAGE
Goto Forum:
  


Current Time: Wed Dec 07 20:21:38 CST 2016

Total time taken to generate the page: 0.20823 seconds