본문 바로가기

Oracle/PL

Oracle/PL 2019. 12. 23. PL Trigger 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110/* Procedure : insert, delete, update IN, OUT Function : select RETURN Trigger : 촉발시키다, 스스로 발생하다. callback : 자동호출 자동 호출 함수 old(이전값), new(새값) insert X O delete O X update O O */..
Oracle/PL 2019. 12. 21. PL 응용문제 (프로시져, 함수) 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816..
Oracle/PL 2019. 12. 20. PL function(함수) 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364-- 함수-- 매개변수, return 값-- select 구문 CREATE OR REPLACE FUNCTION func(p_val IN NUMBER) RETURN NUMBER IS v_val NUMBER;BEGIN v_val := p_val; v_val := v_val * 2; RETURN v_val;END;/ SELECT func(24) FROM DUAL; SET SERVEROUTPUT ON CREATE OR REPLACE FUNCTION tax(p_value IN NUMBER) return ..
Oracle/PL 2019. 12. 20. PL Procedure 프로시져, Cursor 커서 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816..
Oracle/PL 2019. 12. 19. PL 기초 활용 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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 12..

티스토리툴바