oracle中with原理,oracle中的WITH关键字，对等于是试图

WITH V_DOCID AS

(

SELECT b.doc_id id

FROM tb_oa_doc_base b

join tb_oa_doc_recv c

on b.doc_id = c.doc_id

where b.flow_status <> 0

and ((c.sec_level = 4 and is_pub = 1) or

b.doc_id in (select doc_id

from TB_OA_DOC_RECV_PER a

where 1=1

and a.is_readed = 1))

or b.doc_id in (select w2.doc_id

from (select row_number() over(partition by w1.doc_id, w1.applay_id order by w1.doc_id, w1.applay_id) row_num,

w1.doc_id,

w1.applay_id

from (select t1.doc_id, t.applay_id

from tb_wf_proc_log t

join TB_OA_DOC_REF_PROC t1

on t.processinst_id = t1.proinstid) w1) w2

where w2.row_num = 1 )

)

select  *   from   V_DOCID