justice_jl的专栏

单表分页 ================   SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM trz_project) A )WHERE RN BETWEEN 11 AND 20   多表链接 左链接 ==================  SELECT * FROM (SELECT A.* , ROWNUM RN...

  新增表字段 ALTER TABLE tablename ADD columnname coltype; 例子： ALTER TABLE TRZ_PROJECT ADD PROJECTPARTIESNAME vachar2(600); commit;

 序列 sequence 的SQL   -- Create sequence create sequence SEQ_ESTIMATEminvalue 1maxvalue 9999999999999999999999999999start with 1increment by 1cache 20;