Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
autonumber
- Thread starter huBBLe
- Start date
Use a database trigger which populates the auto-number from a sequence e.g.
CREATE OR REPLACE TRIGGER FUND_SERIES_TYPE_PK_AUDIT
BEFORE INSERT
ON FUND_SERIES_TYPE
FOR EACH ROW
-- PL/SQL Block
begin
select fund_series_type_seq_1.nextval, user, sysdate
into :new.fst_num,
:new.update_userid,
:new.update_timestamp
from dual;
end;
CREATE OR REPLACE TRIGGER FUND_SERIES_TYPE_PK_AUDIT
BEFORE INSERT
ON FUND_SERIES_TYPE
FOR EACH ROW
-- PL/SQL Block
begin
select fund_series_type_seq_1.nextval, user, sysdate
into :new.fst_num,
:new.update_userid,
:new.update_timestamp
from dual;
end;
- Status