Guest User

Untitled

a guest
May 26th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. create table pop_temp_all as
  2. select * from pop_populate;
  3.  
  4. create table pop_temp as
  5. select * from pop_populate
  6. where stroffice='440305008000';
  7.  
  8. alter table pop_populate disable primary key cascade;
  9. truncate table pop_populate;
  10.  
  11. insert into pop_populate
  12. select * from pop_temp ;
  13.  
  14. commit;
  15.  
  16. alter table pop_populate enable primary key;
  17.  
  18. drop table pop_temp;
Add Comment
Please, Sign In to add comment