Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table pop_temp_all as
- select * from pop_populate;
- create table pop_temp as
- select * from pop_populate
- where stroffice='440305008000';
- alter table pop_populate disable primary key cascade;
- truncate table pop_populate;
- insert into pop_populate
- select * from pop_temp ;
- commit;
- alter table pop_populate enable primary key;
- drop table pop_temp;
Add Comment
Please, Sign In to add comment