这个不难,有个实例就可以很快学会。
WHENEVER SQLERROR CONTINUE;
DROP PUBLIC SYNONYM SATS_PORTFOLIO_SEQ;
DROP SEQUENCE SATS_PORTFOLIO_SEQ;
WHENEVER SQLERROR EXIT SQL.SQLCODE;
CREATE SEQUENCE SATS_PORTFOLIO_SEQ
MINVALUE 1
START WITH 1
INCREMENT BY 1
CACHE 20;
CREATE PUBLIC SYNONYM SATS_PORTFOLIO_SEQ FOR SATS_PORTFOLIO_SEQ;
开头的部分是清除同名sequence