PLSQL 썸네일형 리스트형 Dynamic PL/SQL example. reference : http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg09dyn.htm create or replace procedure salart_raise ( raise_percent number, job varchar2) is type loc_array_type is table of varchar2(40) index by binary_integer; dml_str varchar2(200); loc_array loc_array_type; begin -- bulk fetch the list of office locations select location bulk collect into loc_array from offices; --.. 더보기 이전 1 다음