develog

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

private void test(Object... args) {System.out.println(">> test()");for (int i = 0; i < args.length; i++) {System.out.println(" " + i + ". " + args[i]);}}

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 ;

ls -lt temp | more

du -h data/temp