随笔分类 -  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 阅读全文
posted @ 2017-09-18 14:19 develop_wangzhi 阅读(12394) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-08-24 09:56 develop_wangzhi 阅读(105) 评论(0) 推荐(0)