목록DB (158)

develog

[Oracle] sequence 특정 값 이상 올리기

MY_SEQ 를 100,000 올리기 ALTER SEQUENCE MY_SEQ INCREMENT BY 100000; SELECT MY_SEQ.NEXTVAL FROM DUAL; ALTER SEQUENCE MY_SEQ INCREMENT BY 1;
DB/Oracle 2019. 6. 19. 11:21
[Oracle] outer join test

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..
DB/Oracle 2019. 5. 28. 14:05
[MySql] Database, User, AutoCommit 정보

현재 사용자 확인 SELECT USER(); 현재 DB 확인 SELECT DATABASE(); AUTOCOMMIT 정보 SELECT @@AUTOCOMMIT; AUTOCOMMIT 활성화 상태 AUTOCOMMIT 비활성화 상태
DB/MySQL 2019. 4. 4. 10:11
[MSSQL] 프로시저 소스

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/MSSQL 2019. 3. 29. 16:39
[MSSQL] 기본 명령어

현재 DB명select db_name() DB 변경use my_db
DB/MSSQL 2019. 3. 26. 11:13
[Oracle] sqlplus 엑셀 export

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
DB/Oracle 2019. 3. 21. 16:56
Prev 1 2 3 4 ··· 27 Next