随笔分类 - Oracle
摘要:select t.applicant_id, t.organ_id, t.apply_date,t.policy_id from (select r.applicant_id, r.organ_id, r.apply_date, r.policy_id, row_number() over(part
阅读全文
摘要:1. 复制表结构及其数据: create table table_name_new as select * from table_name_old 2. 只复制表结构: create table table_name_new as select * from table_name_old where
阅读全文

浙公网安备 33010602011771号