develog

MERGE INTO ATESTUSING DUALON (SEQ = 12)WHEN MATCHED THENUPDATE SETTITLE = 'UPDATE'WHEN NOT MATCHED THENINSERT (SEQ, TITLE)VALUES (12, 'INSERT')

--view 생성, 수정CREATE OR REPLACE VIEW VW_TESTASSELECT DEPT_SEQ, DEPT_NM, USE_YNFROM TB_DEPT; --view 삭제DROP VIEW VW_TEST;

REGEXP_LIKE(USER_NM, '[ㄱ-힣]')REGEXP_LIKE(USER_NM, '[a-zA-Z0-9]')

SELECT * FROM V$VERSION;

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';

CREATE SEQUENCE TEST_SEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE NOCACHE NOCYCLE ; DROP SEQUENCE TEST_SEQ ; SELECT TEST_SEQ.NEXTVAL FROM DUAL ; SELECT TEST_SEQ.CURRVAL FROM DUAL ; ALTER SEQUENCE TEST_SEQ INCREMENT BY 2 ;