블로그
- 땡땡이 분홍색 쓰레기 봉지 Garbage Transformed into Incredible Green Art Installation It’s an unfortunate but necessary evil that public art installation, entitled TRASH:anycoloryoulike; the artists roam select Manhattan streets and replace
- 저장형 함수 테스트 'XSOFT_TAB_FUNC' Stored Function 생성CREATE OR REPLACE FUNCTION XSOFT_TAB_FUNC(p_val NUMBER) RETURN NUMBER AS v_return_val NUMBER := 0;BEGIN SELECT DECODE(p_val, 1, p_val * 1.5, 2, p_val * 2) INTO v_return_val
- sys_refcursor a sys_refcursor and loops on that cursor and prints out (dbms_output) what it fetches: create or replace procedure proc_ref_cursor (rc in sys_refcursor) as v_a number; v_b varchar2(10); begin loop fetch rc into
← 이전
2 페이지