잡다쿼리 KO16KSC5601, WE8DEC, US7ASCII select 'drop table '||tname||' cascade constraint;' from tab select 'drop sequence '||sequence_name||';' from user_sequences select 'create sequence '||sequence_name||' increment by 1 start with '||(last_number + 1) ||' maxvalue 9999999999 nocycle;' from user_sequences@sims select 'create table '||tname||' as select * from '||tname||'@sims;' from tab@sims create seq.. 더보기 유저가 다른 같은 데이터 이관 connect sims/sims grant all on sa_fceq_mstr to newsms connect newsms/newsms select * from sims.sa_fceq_mstr insert into sct_fceq_mstr(fceq_mstr_id, .........) (select fceq_mstr_id,.......... from sims.sa_fceq_mstr) 더보기 db컨트롤 퀴리문 정리 KOREAN_KOREA.KO16KSC5601 AMERICAN_AMERICA.US7ASCII '시퀀스 생성 select 'create sequence SQ_'||tname ||' INCREMENT BY 1 START WITH 1 MAXVALUE 99999999999999999999999999 cycle;' from tab SELECT 'DROP SEQUENCE ' || SEQUENCE_NAME || ';' FROM USER_SEQUENCES '시퀀스 보기 Select * from user_sequences; '컨스트레인트 SELECT * FROM USER_CONS_COLUMNS WHERE TABLE_NAME = 'PFGO01IT' 'user 테이블을 볼수 있도록 한다. select table_name fr.. 더보기 이전 1 ··· 71 72 73 74 75 76 77 다음