Hey Guys,
I am using jdeveloper Studio Edition Version 11.1.2.1.0.
I would like to assign a sequence that i attached a string to my PK attribute like AP2013081000.
Could anyone assist how the above request can be achieved in adf?
Below is the trigger and how could i use it to save in my attribute?
create or replace
TRIGGER LEARNER_TRG
BEFORE INSERT ON LEARNER
FOR EACH ROW
BEGIN
<<COLUMN_SEQUENCES>>
BEGIN
IF :NEW.STUDENTNO IS NULL OR :NEW.STUDENTNO < 0 THEN
SELECT TO_CHAR('AP' || to_char(sysdate, 'YYYYMM')|| LEARNER_SEQ.NEXTVAL) INTO :NEW.STUDENTNO FROM DUAL;
END IF;
END COLUMN_SEQUENCES;
END;
I did use the DBSequence datatype
only for
TRIGGER LEARNER_TRG
BEFORE INSERT ON LEARNER
FOR EACH ROW
BEGIN
<<COLUMN_SEQUENCES>>
BEGIN
IF :NEW.STUDENTNO IS NULL OR :NEW.STUDENTNO < 0 THEN
SELECT to_char(sysdate, 'YYYYMM')|| LEARNER_SEQ.NEXTVAL INTO :NEW.STUDENTNO FROM DUAL;
END IF;
END COLUMN_SEQUENCES;
END;
Regards,
Steve