블로그
- 프로시저에서 배열, 커서 Type 사용 해 보자.. -- VARCHAR2 형 배열 선언 TYPE ARRAY_VARCHAR IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER; -- NUMBER 형 배열 선언 TYPE ARRAY_NUMBER IS TABLE OF NUMBER(18,3) INDEX BY BINARY_INTEGER; -- 커서 타입 선언 TYPE TYPE_CURSOR
- VARCHAR2 -> CLOB Add a new temporary CLOB column at the end of the existing table 2. Empty the existing VARCHAR2-column: Update my table set VARCHAR2-column = NULL; 4.
- Switch by Yuko Shibata Called Switch, the project features one partition that slides out over the dining table to create a meeting The second bookcase pivots round at the end of the day to reveal a bedroom.
- 테이블로 끝나는 MS Word 마지막 페이지 지우기 => 대충 이방법 이용 Table at the end of the documentIf there is a table at the very end of your document, The end-of-table marker cannot hold this information because it contains information about the for...
- It’s Not Easy Turning Co-op Boards Green It’s Not Easy Turning Co-op Boards Green By MIREYA NAVARRO Seated at an oval table with spreadsheets “I don’t want us to be all caught up in green and end up in the red,” he said.
- 저장형 함수 테스트 'XSOFT_TAB' 테이블 생성 CREATE TABLE XSOFT_TAB (VAL_1 NUMBER);그리고 테스트할 Stored Function을 생성해 보겠습니다.2. SELECT DECODE(p_val, 1, p_val * 1.5, 2, p_val * 2) INTO v_return_val FROM DUAL; RETURN v_return_val;END
- sys_refcursor begin loop fetch rc into v_a, v_b; exit when rc%notfound; dbms_output.put_line(v_a || ' ' || v_b); end loop; end; / Here's a table that we will use to select from: create table table_ref_cursor ( a number
← 이전
2 페이지