摘要:
调查询过程 pcx_tzgl_tzzh DO$$DECLAREret_ref refcursor;one_row record;v_a integer;v_c varchar;v_b integer;i_xmmc varchar;i_yefw varchar;begin call pcx_tzgl_ 阅读全文
摘要:
do $$ declare str text :='{ "tzmxList": [ { "ZCPH": "CPH000000001", "CPID": "1111", "SYJB": "11", "TZJE": "1000000" }, { "ZCPH": "CPH000000002", "CPID 阅读全文
摘要:
create or replace procedure pro_str_json( o_code out int, i_str in VARCHAR2)is jsonObj CLOB;v_jsonStr VARCHAR2(4000);v_p json; v_id NUMBER;v_name VARC 阅读全文