创建视图
各位大侠:
麻烦问一下,下面这句话是什么意思尤其是@后面
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;
------解决方案--------------------DBLINK 访问数据库
------解决方案--------------------from cc_calllog@CALL.SERVER --通过CALL.SERVER这个dblink查到指定用户的表cc_calllog
CALLERCODE as caller --从表cc_calllog里拿出CALLERCODE字段然后改名为caller当作视图ccv_callrecord 的字段