In your code is present the row
If collection (rr_tab) is empty, then oracle is generating of the...
select sys_context('userenv','proxy_user'),sys_context('userenv','session_user') , sys_context('userenv','current_user') from...
On db, may to using a some of view from db dictionary,with dependent of conditions by your task.
For example : v$sql,v$sqlarea.
What is returning this query :select * from all_registry_banners l where l.banner like '%XML%' ;
Please,provide here result this query from two your of database : select * from sys.dba_registry_sqlpatch
You should always use explicit conversions.
You should always use explicit transformations.
Using implicit conversions - the current settings of...
The generation temp-space above 50 GB, it is possible with a hierarchical query, as it depends on the amount of data processed.
And, usually, it...
The use of operators AND / or / NOT or functions depends only on your task,and the complexity of the processing logic you need to implement.
Can explain what is your question?
1. Using XML in SQL
1) Why you use anonymous pl/sql block in IF-statement?
2) This line "IF INSTR( vstrout,'&') " is contain not escaped char
Are you need stored source of xml documents?
Task could be solved of a few path: by shell scripts and (sqlplus or sql loader), simple of...
How complex a document you plan to create : with XSD scheme or not ?
For an example , to support database environments development, test, you can use "thin clones" or tools (ODI,OGG,...) or manual copy if your db is...
1) For Orace: HS
2) For MS SQL:
if you'll have some question, then write here.
For education :
select dummy from dual;
Provide here your source code of the procedure MYPROC.SCHED_SQL_QUERY
select listagg(column_expression, ', ') within group (order by column_position)
if you just need to collect a branch from the child to the parent, you do not need to scan "all parents"
for a example....,'11114' '44442'...
parents at what level do you need to compare?
also,provide here INSERT statements for you table.