Personal notes-oracle, notes-oracle
Sequence
select * from user_sequences select last_number from user_sequences where sequence_name='T_JGXX_POLY_SEQ';alter sequence T_JGXX_POLY_SEQ increment by 1;SELECT T_JGXX_POLY_SEQ.NEXTVAL FROM DUAL;
Meger
merge into t_jgxx_poly jgusing t_jgxx_poly_view von (jg.id=v.id and v.geometry is not null)WHEN MATCHED THEN update set jg.geometry = v.geometryWHEN NOT MATCHED THEN INSERT (id,geometry) values(v.id,v.geometry)
View
create or replace view t_jgxx_poly_view asselect xz.geometry,jg.id from t_jgxx jg, XZQH_CNTY_POLY xz where jg.xzqh=xz.cnty_code and xz.geometry is not nullunion allselect xz.geometry,jg.id from t_jgxx jg, XZQH_PREF_POLY xz where jg.xzqh=TO_CHAR(xz.PREF_CODE) and xz.geometry is not nullunion allselect xz.geometry,jg.id from t_jgxx jg, XZQH_PROVINCE_POLY xz where jg.xzqh=TO_CHAR(xz.PROV_CODE) and xz.geometry is not null;