I have a table called LABOR. In this table I have columns named:
LABORCODE, LA21, NAME, ROWSTAMP
I am wanting to create a trigger that will insert into LABORCODE after an insert into LABOR. My example is that I insert a new record so I want LABORCODE to equal 'JOHN'. My real desire is to have it insert a substr such as substr(name, 1, 4)||substr(rowstamp, 1, 4) into LABORCODE as a new record is created.
I have tried everything I know how to do. I get valid triggers as far as ORACLE DBA are concerned and SQLPLUS, but they never work.
Can someone help?
John
LABORCODE, LA21, NAME, ROWSTAMP
I am wanting to create a trigger that will insert into LABORCODE after an insert into LABOR. My example is that I insert a new record so I want LABORCODE to equal 'JOHN'. My real desire is to have it insert a substr such as substr(name, 1, 4)||substr(rowstamp, 1, 4) into LABORCODE as a new record is created.
I have tried everything I know how to do. I get valid triggers as far as ORACLE DBA are concerned and SQLPLUS, but they never work.
Can someone help?
John