Re: Trigger to prevent insert of multiple rows

In article <42i93k$bi4_at_drilex.dri.mgh.com>, rcrystal_at_dri.mcgraw-hill.com (Rona Crystal) says:
>
>
>I am a new user to Oracle. My project is to convert an existing Sybase
>database. The trigger that I am trying to convert prevents multiple rows
>from being inserted in a single insert statement.
 <SNIP>
>Does anybody have a suggestion on how I can implement this? This concept of
>preventing multiple row inserts is used in many of the tables in this
>system.
>Thanks for any help provided.
>
>Rona Crystal

Perhaps the simplest way to prevent multiple inserts is by using a unique index??

                                          Brian
--
Brian Graham                    .
Programmer / DBA        ._______|_______. Tel: 613-560-5470
Public Service Alliance       \(*)/       Fax: 613-563-3492
of Canada                     o/ \o       Email: grahamb_at_psac.com