create a sequence in function or procedure , if that does not exist, however if exist return the nextval
execute immediate ‘select ‘ || p_table_name || ‘_id_dynamic_seq.nextval from dual’ into v_id; exception when others then execute immediate ‘create sequence ‘ || p_table_name || ‘_id_dynamic_seq’; execute immediate ‘select ‘ || p_table_name || ‘_id_dynamic_seq.nextval from dual’ into v_id; end; —asdas return v_id;that us oracle sequence New contributor levan gogritchiani is a new contributor to this site. […]