반응형
1 2 3 4 | SELECT * FROM USER_SOURCE WHERE 1=1 AND TEXT LIKE '%검색어%' | cs |
'데이터베이스' 카테고리의 다른 글
[오라클]LISTAGG 중복제거 (0) | 2018.06.16 |
---|---|
[DB2]프로시져를 오버로드해서 쓰고 지울때 (0) | 2017.07.17 |
1 2 3 4 | SELECT * FROM USER_SOURCE WHERE 1=1 AND TEXT LIKE '%검색어%' | cs |
[오라클]LISTAGG 중복제거 (0) | 2018.06.16 |
---|---|
[DB2]프로시져를 오버로드해서 쓰고 지울때 (0) | 2017.07.17 |
오라클이 설치하기 싫어서 실행장면은 스샷 없음 ㅠ
1 2 3 4 5 6 | SELECT regexp_replace(LISTAGG( 필드 || ',' ) WITHIN GROUP ( ORDER BY 정렬기준 필드) , '([^,]+)(,\1)+', '\1') FROM T | cs |
[오라클]procedure Function Package 검색 (0) | 2018.07.07 |
---|---|
[DB2]프로시져를 오버로드해서 쓰고 지울때 (0) | 2017.07.17 |
https://stackoverflow.com/questions/36947083/deleting-a-non-unique-procedure-on-db2
Assuming this is DB2 for LUW.
DB2 allows you to "overload" procedures with the same name but different number of parameters. Each procedure receives a specific name, which can be provided by you or generated by the system and which will be unique.
To determine the specific names of your procedures, run
SELECT ROUTINESCHEMA, ROUTINENAME, SPECIFICNAME FROM SYSCAT.ROUTINES
WHERE ROUTINENAME = 'BT_CU_ODOMETER'
You can then drop each procedure individually:
DROP SPECIFIC PROCEDURE <specific name>
[오라클]procedure Function Package 검색 (0) | 2018.07.07 |
---|---|
[오라클]LISTAGG 중복제거 (0) | 2018.06.16 |