如下的视图在oracle9i中怎么转换
create or replace view v_v8_tbl_agent_status as
(
select agent_code,update_time,user_code,user_name,user_area,current_queue_id,class_id,class_name,extension,current_status,
status_start_time,caller,computer_ip,call_center,signin_id,is_warn,warn_item,agent_sub_status,classwork_id,reserve_code1,
regexp_substr(queue_id,'[^;]+',1,line) as queue_id from tbl_agent_status,(select rownum as line from tbl_agent_status connect by rownum<=(select
max(length(queue_id)-length(replace(queue_id,';','')))+1 from tbl_agent_status)) where regexp_substr(queue_id,'[^;]+',1,line) is not null);谢谢！
create or replace view v_v8_tbl_agent_status as
(
select agent_code,update_time,user_code,user_name,user_area,current_queue_id,class_id,class_name,extension,current_status,
status_start_time,caller,computer_ip,call_center,signin_id,is_warn,warn_item,agent_sub_status,classwork_id,reserve_code1,
regexp_substr(queue_id,'[^;]+',1,line) as queue_id from tbl_agent_status,(select rownum as line from tbl_agent_status connect by rownum<=(select
max(length(queue_id)-length(replace(queue_id,';','')))+1 from tbl_agent_status)) where regexp_substr(queue_id,'[^;]+',1,line) is not null);谢谢！
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货