Topic: Call of a part of a script from the main script.
Let's assume that there are 2 scripts: 1.sql and 2.sql .
The Source code 1.sql:
with t1 as (select 1 a from dual) @2.sql /
The Source code 2.sql:
select * from t1
As we see, 2.sql it is caused from 1.sql .
At start 1.sql - we receive an error
"00928. 00000 -" missing SELECT keyword"
Actually a question: how to implement script sharing, in a case when is with, and further, in other script, already is select?
Tried to launch in SQL Developer and SQL*PLUS - result identical. The script 2.sql is visible (at least if it to cause separately the code is executed).