Notice
Recent Posts
Recent Comments
Link
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
Tags
- Windows 10
- ssh
- 단축키
- netsh
- IntelliJ
- JavaScript
- Eclipse
- port
- Windows
- Mac
- context
- profile
- xargs
- DB 도메인
- 네트워크
- resource
- GIT
- lsof
- Source
- copy-dependencies
- grep
- import
- VirtualBox
- bash
- Quartz
- maVen
- web.xml
- find
- tomcat
- 공통표준용어
Archives
- Today
- Total
목록DB/Oracle (88)
develog
MERGE INTO
MERGE INTO ATESTUSING DUALON (SEQ = 12)WHEN MATCHED THENUPDATE SETTITLE = 'UPDATE'WHEN NOT MATCHED THENINSERT (SEQ, TITLE)VALUES (12, 'INSERT')
DB/Oracle
2013. 5. 30. 16:00
view
--view 생성, 수정CREATE OR REPLACE VIEW VW_TESTASSELECT DEPT_SEQ, DEPT_NM, USE_YNFROM TB_DEPT; --view 삭제DROP VIEW VW_TEST;
DB/Oracle
2013. 4. 26. 15:57
REGEXP_LIKE
REGEXP_LIKE(USER_NM, '[ㄱ-힣]')REGEXP_LIKE(USER_NM, '[a-zA-Z0-9]')
DB/Oracle
2013. 3. 18. 15:51
Oracle 버전 확인
SELECT * FROM V$VERSION;
DB/Oracle
2013. 2. 27. 13:09
ORA-04091
ORA-04091: 테이블 BB가 변화하고 있어서 트리거/함수가 이를 볼 수 없습니다 FN_TEST(P_SEQ NUMBER)RETURN VARCHAR2ISBEGIN SELECT * FROM BB WHERE SEQ = P_SEQ; END; UPDATE BB ZSET NOTE = FN_TEST(Z.SEQ) --ORA-04091 에러!WHERE SEQ = '1';
DB/Oracle
2013. 2. 26. 10:17