我发现SQL server与oracle的SQL语法有很大的不同。相当难转换，有谁能帮我转换下面SQL server 这个视图 到oracle
=================================================

Create  VIEW vFSENBUDraftView
AS
SELECT TOP 100 PERCENT t.objid,t.pobjid,t.subject,t.[description],t.createdate,isNull(t.updatedate, t.createdate) as lastupdate,t.createby,

       (SELECT k.fullname
        FROM kluser k
        WHERE k.uid=t.createby) AS CreateAuthor,

       (SELECT k.fullname
        FROM kluser k
        WHERE k.uid=t.updateby) AS UpdateAuthor,

       (SELECT TOP 1 DVC.dvcid
        FROM DVC
        WHERE DVC.objid=t.objid ORDER BY DVC.dvcid DESC) AS LastVersion,

       (SELECT Sum(filesize)
        FROM vFileName v
        WHERE v.tdobjid IN (t.objid) GROUP BY v.tdobjid) FileSize

FROM tcdocument t
WHERE t.objstate='D' AND t.objstatus='A' ORDER BY t.createdate DESC
================================================