일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
- xargs
- DB 도메인
- VirtualBox
- lsof
- web.xml
- tomcat
- grep
- profile
- bash
- Mac
- find
- ssh
- netsh
- 공통표준용어
- maVen
- import
- resource
- Windows 10
- Source
- copy-dependencies
- JavaScript
- context
- 네트워크
- GIT
- 단축키
- Eclipse
- port
- IntelliJ
- Quartz
- Windows
- Today
- Total
목록DB (158)
develog
Procedure 생성 CREATE PROCEDURE SP_TEST @AA VARCHAR(10), @BB VARCHAR(10), @CC VARCHAR(10) OUTPUT AS DECLARE @RET VARCHAR; SET @RET = '33'; SET @CC = @AA + @BB + @RET; GO Procedure 수정 ALTER PROCEDURE ... Procedure 실행 DECLARE @RET VARCHAR(10); EXEC SP_TEST @AA = '11', @BB = '22', @CC = @RET OUTPUT; PRINT @RET; Procedure 삭제 DROP PROCEDURE SP_TEST;
Function 생성 CREATE FUNCTION FN_TEST(@P_MSG VARCHAR(10)) RETURNS VARCHAR AS BEGIN DECLARE @V_RETURN VARCHAR(100); DECLARE @V_STR VARCHAR(10); SET @V_STR = 'abc'; SET @V_RETURN = concat(@V_STR, @P_MSG); RETURN @V_RETURN; END Function 수정 ALTER FUNCTION ... Function 실행 SELECT DBO.FN_TEST('ZZZ') RET_MSG Function 삭제 DROP FUNCTION FN_TEST;
SHOW CREATE PROCEDURE MY_PROC_NAME;
http://dev.mysql.com/doc/refman/5.7/en/information-schema.html information_schema.ENGINESinformation_schema.CHARACTER_SETSinformation_schema.EVENTSinformation_schema.GLOBAL_STATUSinformation_schema.GLOBAL_VARIABLESinformation_schema.PARAMETERSinformation_schema.TABLESPACESinformation_schema.TRIGGERSinformation_schema.USER_PRIVILEGES information_schema.TABLESinformation_schema.TABLE_CONSTRAINTSin..
--시간차가 5분 미만인 건AND REG_TS - TO_TIMESTAMP('2016/11/04 15:05:19', 'YYYY/MM/DD HH24:MI:SS') < INTERVAL '05:00' MINUTE TO SECOND
SELECT TYPE, NAME --, LINE --, TEXT , REGEXP_REPLACE(TEXT, 'FUNCTION|PROCEDURE|;|\s|\(.*', '') TEXT2FROM( SELECT TYPE, NAME, LINE, UPPER(TEXT) TEXT FROM USER_SOURCE WHERE TYPE = 'PACKAGE' AND (1=2 OR TEXT LIKE '%FUNCTION%' OR TEXT LIKE '%PROCEDURE%' ))ORDER BY TYPE, NAME, LINE