plsql - Oracle SQL - select a subquery from a view

Question

I have a short and quick question regarding the feasability of selecting a subquery that exists within a view.

Say I have a view that contains a subquery using a "with as" select, like:

create or replace view my_view as
with subquery as (
   select * from table)
select something... view logic continues...

Is there some way to select the subquery outside of this view, to re-use the definition of the subquery without copy-pasting it? I see an obvious alternative to have the subquery used in the view as a stand-alone view, and then implementing this other places as needed - but just to clarify, I'd like to know if there exists alternatives.

Answer 1

等待大神答复