declare i varchar2(1000); n number; begin i:='%D0FC02EAR11005%'; select po_header_id into n from po_headers_all where segment1 like i; dbms_output.put_line('n := ' || n); end;
declare i varchar2(1000); n number; begin i:='%D0FC02EAR11005%'; select po_header_id into n from po_headers_all where segment1 like i; dbms_output.put_line('n := ' || n); end;
转载于:https://www.cnblogs.com/toowang/p/3473452.html