本文共 858 字，大约阅读时间需要 2 分钟。

PL/SQL??????

vs_string VARCHAR2(2000);vn_number NUMBER;vc_cur SYS_REFCURSOR;vl_row wx_supplier%ROWTYPE;

2. ??????

type type_wx_supplier is record(  id NUMBER,  name VARCHAR2(200));

3. ?????

vv_row type_wx_supplier;

4. SQL??

BEGIN  dbms_output.put_line('begin');  select wxs.* into vl_row from wx_supplier wxs where rownum=1;  dbms_output.put_line('end');  end;

5. Cursor??

OPEN cur FOR vs_result_sql;LOOP  FETCH cur INTO empdtl;  EXIT WHEN cur%NOTFOUND;  dbms_output.put_line(empdtl.id);END LOOP;CLOSE cur;

6. ????

FOR cu in (select * from v_tl_wk_action_codeinfo)  loop    dbms_output.put_line(cu.form_id);  end loop;

7. ????

EXECUTE IMMEDIATE 'select * from wk_my_bill where id in(select max(id) from wk_my_bill)';commit;

8. ??????

type empdtlrec is record(  id VARCHAR2(200),  name VARCHAR2(200),  need_remark VARCHAR2(200),  remark_title VARCHAR2(200));empdtl empdtlrec;

转载地址：http://htpfk.baihongyu.com/