Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

concatenate a string and a sequence number

steve kalengaAug 15 2013 — edited Sep 3 2013

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

This post has been answered by Timo Hahn on Aug 15 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2013
Added on Aug 15 2013
4 comments
1,245 views