develog

MY_SEQ 를 100,000 올리기 ALTER SEQUENCE MY_SEQ INCREMENT BY 100000; SELECT MY_SEQ.NEXTVAL FROM DUAL; ALTER SEQUENCE MY_SEQ INCREMENT BY 1;

WITH TA AS ( SELECT 1 SEQ, 'A1' NOTE FROM DUAL UNION ALL SELECT 2 SEQ, 'A2' NOTE FROM DUAL UNION ALL SELECT 3 SEQ, 'A3' NOTE FROM DUAL UNION ALL SELECT 4 SEQ, 'A4' NOTE FROM DUAL UNION ALL SELECT 5 SEQ, 'A5' NOTE FROM DUAL ), TB AS ( SELECT 1 SEQ, 'B1' NOTE FROM DUAL UNION ALL SELECT 2 SEQ, 'B2' NOTE FROM DUAL UNION ALL SELECT 3 SEQ, 'B3' NOTE FROM DUAL ), TC AS ( SELECT 3 SEQ, 'C3' NOTE FROM DU..

sqlplus 로 sql 파일을 실행해서 엑셀파일로 저장 C:\test2.sqlset echo offset feed offset termout offset markup html on spool oncolumn filename new_val filenameselect 'C:\TEST2_'||to_char(sysdate, 'YYYYMMDD')||'.xls' filename from dual;spool &filename SELECT *FROM AATEST; spool offset markup html off quit cmd C:\> sqlplus username/password@TNS_name @C:\test2.sql

database link 생성CREATE DATABASE LINK 디비링크이름 CONNECT TO 아이디 IDENTIFIED BY 비밀번호 USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL=TCP)(HOST=데이터베이스IP)(PORT=1521) ) ) (CONNECT_DATA =(SERVICE_NAME=서비스명) ) )' ; database link 삭제DROP DATABASE LINK 디비링크이름; database link 사용SELECT *FROM 테이블이름@디비링크이름;

Oracle Database 11g Release 1 JDBC Drivershttps://www.oracle.com/technetwork/apps-tech/jdbc-111060-084321.html

Oracle JDBC FAQhttp://www.oracle.com/technetwork/topics/jdbc-faq-090281.html Which version of JDBC drivers are supported ?http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#01_01