oracle中创建sequence

 这个不难，有个实例就可以很快学会。

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