PL/SQL (MOSC)

MOSC Banner

modification of the existing trigger to add date validation

edited Oct 19, 2011 3:59AM in PL/SQL (MOSC) 16 commentsAnswered
 Following is the code of my existing trigger:

after insert or update on user.table
for each row
declare
v_reflag char(1) :='0';
begin
if INSERTING then
insert into user2.table_copy
(T$QONO,
 T$REVI,
 T$COMP,
 T$CUNO,
 T$CCOR,
 T$CDEL,
 T$QSTA,
 T$QDAT,
 T$EXPD,
 T$DDAT,
 T$DTME,
 T$ODIS,
 T$CCUR,
 T$FCRT,
 T$RATS,
 T$RATF,
 T$COTP,
 T$CREP,
 T$CVYN,
 T$CCRS,
 T$CFRW,
 T$CPLS,
 T$PLDD,
 T$PCPR,
 T$PCTX,
 T$CCTY,
 T$CLAN,
 T$CDEC,
 T$CRTE,
 T$CPAY,
 T$CBRN,
 T$CREG,
 T$REFA,
 T$REFB,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center