목록2019/03 (14)

develog

[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
[Linux] ps kill

ps 로 검색후 kill 하기 ps aux | grep java | grep -v grep | grep 'tomcat6/' | awk '{print $2}' | xargs kill -9
OS & Shell/Linux 2019. 3. 28. 17:18
[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
[Java] SqlSession.getMapper

SqlSession.getMapper T getMapper(Class type);
카테고리 없음 2019. 3. 12. 17:41
[MySql] date, timestamp

SELECT CURRENT_TIMESTAMP(), CURRENT_DATE(), NOW()
카테고리 없음 2019. 3. 8. 17:16
Prev 1 2 3 Next