创建视图
各位大侠:
麻烦问一下,下面这句话是什么意思尤其是@后面
create or replace view ccv_callrecord as
select id as id,
CALLERCODE as caller,
calledcode as called,
STARTTIME as calltime,
endtime as endtime,
vocfile as callrec,
CONNECTTIMELEN as longtime,
MAKECALLTIMELEN as MAKECALLTIMELEN,
CONNECTTIMELEN as CONNECTTIMELEN,
CALLTYPE as CALLTYPE,
AGENTWORKID as agentcode,
calldate as calldate,
AGENTNAME as AGENTNAME,
SLICNO as SLICNO,
CALLRESULT as callresult,
CNQ as cnq,
'空' as callstatus,
'-1' as content,
'咨询' as callattribute,
islistened as islistened
from
cc_calllog@CALL.SERVER;