HomeОбразованиеRelated VideosMore From: Oracle PL/SQL World

How to Decode XML In Oracle Database?

17 ratings | 3192 views
Sample Code Link: https://github.com/arulxaviers/Decode_XML_In_Oracle Thi video Will Teach you How to Decode XML In Oracle Database? how to read xml file in oracle pl sql extract value from xml oracle dbms_xmlgen.convert ampersand oracle xmltable example oracle xml query examples how to parse xml in oracle pl sql xml parsing in oracle 11g oracle xmltype extract example XMLTYPE XMLREAD Decode XML in Oracle
Html code for embedding videos on your blog
Text Comments (8)
Fireblad 954 (4 months ago)
Hi Dear, thanks for your solution. I appreciate if you or someone can help to bring below complex xml file in oracle table. https://scsanctions.un.org/resources/xml/en/consolidated.xml tried but could't .. so found 3rd party tool and just running the show ... but its a long exercise. Need to define process to directly upload data from XML to Oracle Table. Best Regards
Sazzad Ali (1 year ago)
Dear sir! How about performance if we want to insert 3000 records and process based on some condition specific row.
Oracle PL/SQL World (1 year ago)
Hi Sazzad Thanks for your Question... Its Actually Very easy..I am Just explaining you for Understanding Purpose with Select and Insert Query With Decode...When You have More Amount of Row Like this You have to choose PL SQL ... Below is sample Code: Begin For Rec IN (Your Decode Select Statement) Loop Insert Into Table_Name Values(Rec.Col,Rec.Col...Rec.Col.n); End Loop; End;
kannan kanna (1 year ago)
Very Useful. Can you please do a video on CLOB in detail?
Oracle PL/SQL World (1 year ago)
Thank You for your Valuable Feedback....Will do and revert u
Little Legend (1 year ago)
Excellent video
Oracle PL/SQL World (1 year ago)
http://www.dba-oracle.com/t_extract_value_XML_from_clob.htm Refer this link ...This may helpful for u..
Oracle PL/SQL World (1 year ago)
Thank You for your Valuable Feedback..

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.