declare
deger number:=0;
begin
select SCHEMA_NAME.SEQ_ENG_ENG_BILGILERI_ID.nextval
into deger
from dual;
dbms_output.put_line(deger);
end;
ALTER SEQUENCE PROBBYS.SEQ_ENG_ENG_BILGILERI_ID INCREMENT BY 1000;
SELECT PROBBYS.SEQ_ENG_ENG_BILGILERI_ID.NEXTVAL FROM dual;
ALTER SEQUENCE PROBBYS.SEQ_ENG_ENG_BILGILERI_ID INCREMENT BY 1;
deger number:=0;
begin
select SCHEMA_NAME.SEQ_ENG_ENG_BILGILERI_ID.nextval
into deger
from dual;
dbms_output.put_line(deger);
end;
ALTER SEQUENCE PROBBYS.SEQ_ENG_ENG_BILGILERI_ID INCREMENT BY 1000;
SELECT PROBBYS.SEQ_ENG_ENG_BILGILERI_ID.NEXTVAL FROM dual;
ALTER SEQUENCE PROBBYS.SEQ_ENG_ENG_BILGILERI_ID INCREMENT BY 1;
Comments
Post a Comment