var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need sequence for this logic
As per this logic,for every new entity of id a new autogenerated code will be generated.
This (xyz or sbh or sbi) code should be fetched using select query
(select b_code into table.code from cmp where c_id =145623)
using id(145623). And 001,002 is autogenerated code and should be concentrated with xyz ex: xyz001
Here we can use trigger with sequence
Could you please help me..
create a before trigger on insert on the table an a sequence. In the trigger append xyz to the beginning and
:new.id := 'xyz'||to_char(my_seq.nextval);
Now write the trigger and show us what you wrote
You do not need a parachute to skydive. You only need a parachute to skydive twice.
Well, not really. Such a code would raise
Sequence number should be fetched within the SELECT statement.
PLS-00357: Table,View Or Sequence reference 'MY_SEQ.NEXTVAL' not allowed in this context
As of "001" part, LPAD function will do the job.