Discussion of PL/SQL programming using XDK and related management issues inside Oracle database server. Any question for XML DB functionality, please post your question in Products -> Database-> XML DB.
Hello Everybody! I am not sure whether this is the right place in the forum for my issue and if it is not then please move it to the right place. Here is the situation. I am testing database…(Show moreShow less)
Hi, i want to query XML data via XMLTABLE (see Query.txt in the attachment) - generally it works fine :-). In my case i get an unwanted cartesian join between the groups fatca_oecd.reporting_fi…(Show moreShow less)
Hi All, I have an external data file with XML data. What is the best way to load this data into custom staging tables in Oracle database 11g? I do not have any XML Schema setup. The XML data is…(Show moreShow less)
Hello, i am newby for using xml in the oracle database. I have read some examples, but i am worried about a simple one. I have a simple xml structure like this: <?xml version="1.0"?>…(Show moreShow less)
Hi , I am using the below way to show the data in the xml file. Not getting any error, but data is not coming when i used like. If i copy pasted the xml file data in place of xmltype(…(Show moreShow less)
Hi all, I have a scenerio, wherein i need (report-wise) sum of a summary column (query-wise) based upon distinct values of another column. Please see the snapshot below, for each value of…(Show moreShow less)
Hi, when i execute the following select statement, i get in some rows the error ORA-19279: XPTY0004. The node '/ftc:FATCA_OECD/ftc:FATCA/ftc:ReportingFI' has in some cases more than one…(Show moreShow less)