How can I get ORACLE 7 to mimic INFORMIX serial type functionality?
IOW, I want to have an auto sequencing key data type. I know about create
sequence and all that good stuff but how do I embed the sequencing in
the schema. My guess was to use a trigger but how? Do I use before or
after insert? What does my pl/sql statement look like? Is there another way
to accomplish this? Any examples would be greatly appreciated.
Please don't tell me it has to left up to each and every application.
Thanks in advance,
--
Michael J Matthews 201-326-5212
ATT Corporate ITS International (until next re-org)
attmail!mjmatthews/[att]!attibr!atti14!mjm
mjmatthews_at_attmail.com/mjmatthews_at_icits.att.com