How to insert sequence_name.nextval where sequence_name is stored in string.
Hi,
We have arequirement to insert a new a sequence depending on orgid.so how to use the string variable for sequence name in jdbc to insert value in the system.
This is working fine plsql. But how to use the same in jdbc.
seqnam='AEPL_DEALER_CLAIM_Num_S'||'.nextval';
'select '||seqnam||'.nextval from dual' into a ;
Please help
Thanks in advance