SQL & PL/SQL

Hi,

In teradata database we can write a query like below :

select sls_doc_id, sls_dlvr_doc_id, rank() over (partition by sls_dlvr_doc_id order by sls_dlvr_doc_id) rn
from cdp_analysis.v_sls_dlvr_doc_dtl
QUALIFY rn > 1;

If I want to write an equivalent thing in Oracle then I can write an equivalent like below :

select sls_doc_id, sls_dlvr_doc_id
from
(
select sls_doc_id, sls_dlvr_doc_id, rank() over (partition by sls_dlvr_doc_id order by sls_dlvr_doc_id) rn
from cdp_analysis.v_sls_dlvr_doc_dtl
)
where rn > 1;

I just want to know is any keyword exist in Oracle which is equivalent to QUALIFY of Teradata?

Regards,
Koushik