语句如下:
create or replace procedure pro_ci_main(p_mode in varchar2) is
v_1 varchar2(4000);
begin
--加载客户公司名称信息
v_1 := "create or replace view v_company_info(cust_id, company_name) as select cust_id, WMSYS.WM_CONCAT(nvl(company_name, 'NULL')) from t_customer_address_info addr, t_customer tc where tc.collection_status = (select id from t_sys_code where code_category = 'CCST' and code = '02') and tc.id = addr.cust_id and addr.address_category = (select id from t_sys_code where code_category = 'ADCA' and code = '02') group by cust_id";
execute immediate v_1;
end pro_ci_main;