DB 함수로 DELETE 테스트(질의 안에 DML 작업을 수행할 수 없습니다.)
2023. 5. 19. 13:41
SQL
CREATE FUNCTION DELETE_TEST(TARGET_MBR_NO INTEGER) RETURN VARCHAR2 IS PRAGMA AUTONOMOUS_TRANSACTION; RESULT_DATA INTEGER; BEGIN DELETE FROM ㄱㄱㄱㄱ WHERE MBR_NO = TARGET_MBR_NO; DELETE FROM ㄴㄴㄴㄴ WHERE MBR_NO = TARGET_MBR_NO; DELETE FROM ㄷㄷㄷㄷ WHERE MBR_NO = TARGET_MBR_NO; DELETE FROM ㄹㄹㄹㄹ WHERE MBR_NO = TARGET_MBR_NO; DELETE FROM ㅁㅁㅁㅁ WHERE MBR_NO = TARGET_MBR_NO; DELETE FROM ㅂㅂㅂㅂ WHERE MBR_NO = TAR..