you can use after insert trigger when :new.empni<>:old.empno reset the
sq_num

-----Original Message-----
From: Benjamin Bahrenburg [mailto:[Email Address Removed] Saturday, June 30, 2001 5:32 AM
To: LazyDBA.com Discussion
Subject: View Question


Hello:
I am creating a view. I need a number sequenec that resets itself by
groups.
For Example:

EMPNO(Group) SQ_NUM(number sequence)
1 1
1 2
1 3
2 1
3 1
4 1
4 2

Any ideas

Regards,
Ben


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page