PLSQL 썸네일형 리스트형 [oracle강좌] 오라클 / PL-SQL 에서 쿼리시 Array Processing PL/SQL에서 쿼리시 Array Processing 처리방법 ---------------------------------------------- 임시 테이블 생성 ---------------------------------------------- connect scott/tiger; DROP TABLE bb; CREATE TABLE bb ( empno NUMBER, empname VARCHAR2(10) ); ---------------------------------------------- 풀이 ---------------------------------------------- DECLARE v_array_size CONSTANT INTEGER := 100; v_empno DBMS_SQL.NUMBER_.. Oracle Supplied PL/SQL Packages Package Name Description CTX_ADM Lets you administer servers and the data dictionary. CTX_CLS Lets you generate CTXRULE rules for a set of documents. CTX_DDL Lets you create and manage the preferences, section lists and stopgroups required for Text indexes. CTX_DOC Lets you request document services. CTX_OUTPUT Lets you manage the index log. CTX_QUERY Lets you generate query feedback, count hits.. 이전 1 다음