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..

현재 사용자 확인 SELECT USER(); 현재 DB 확인 SELECT DATABASE(); AUTOCOMMIT 정보 SELECT @@AUTOCOMMIT; AUTOCOMMIT 활성화 상태 AUTOCOMMIT 비활성화 상태

SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'FUNCTION' ORDER BY ROUTINE_NAME ; SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' ORDER BY ROUTINE_NAME ; EXEC SP_HELPTEXT SP_CHESS_MAIN_TASK_INFO ;

현재 DB명select db_name() DB 변경use my_db

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