Thursday, January 3, 2008

Sys.xmlType datatype and parsing XML in Oracle9i, 10g onwards

Oracle9i onwards there is new datatype called sys.xmlType. This provides a great way to handle XML documents with minimal or no parsing required.

Listed below is a sample of how to use the xmlType.

Step 1. Create Table of XML type

CREATE TABLE xml_table( xml_col SYS.XMLTYPE );
Step 2. Insert the following XML into the xml_table defined above

<?xml version="1.0"?>
<email>
    <from>xyz@gmail.com</from>
    <to>xyz1@gmail.com</to>
    <subject>some subject</subject>
    <body>some body</body>
</email>

declare

l_temp sys.xmlType;

begin

l_temp := sys.xmlType.createXML('

<?xml version="1.0"?>
<email>
    <from>xyz@gmail.com</from>
    <to>xyz1@gmail.com</to>
    <subject>some subject</subject>
    <body>some body</body>
</email>'

);

insert into xml_table values ( l_Temp);

Commit;

end;

Step 3. Write select query to extract data from this table. Sample extract query listed below.

select a.xml_col.extract("//from/text()").getStringVal() as from from xml_table a

436 comments:

«Oldest   ‹Older   401 – 436 of 436
Indhu said...

Wondeful Explanation with lots of useful information in this blog. Congrats and Keep Rocking.

QTP Training in Chennai | SAP Training in Chennai | SAP ABAP Training in Chennai | SAP FICO Training in Chennai

SAP Academy said...

Informative post..
SAP Training in Chennai
SAP ABAP Training in Chennai
SAP Basis Training in Chennai
SAP FICO Training in Chennai
SAP MM Training in Chennai
SAP PM Training in Chennai
SAP PP Training in Chennai
SAP SD Training in Chennai

ramya said...

Great post very useful info thanks for this post ....
Devops trainign in chennai

SAP Training in Chennai said...

Very good blog which explains really well about Oracle technology.
SAP Training in Chennai
AWS Training in Chennai
Java Training in Chennai
AWS Exam Center in Chennai

sona roy said...

Thanks for sharing with us, this blog was usefull to me.SEM also known as Search Engine Marketing, is focused on increasing visibility of one's newly setup or a pre-existing website. You are able to improve your site traffic SEO and SMO service. If you want digital marketing agency then go with sem services in Chennai is the best place for it.
sem services in chennai | social media marketing companies in chennai | top 10 seo companies in chennai | top digital marketing companies in chennai | digital marketing services in chennai | best digital marketing company in chennai

raju said...

nice information.......!
inplant training in chennai
inplant training in chennai for it.php
panama web hosting
syria hosting
services hosting
afghanistan shared web hosting
andorra web hosting
belarus web hosting
brunei darussalam hosting
inplant training in chennai

shree said...

very nice....
inplant training in chennai
inplant training in chennai
inplant training in chennai for it
namibia web hosting
norway web hosting
rwanda web hosting
spain hosting
turkey web hosting
venezuela hosting
vietnam shared web hosting

shri said...

nice...
internship in chennai for ece students
internships in chennai for cse students 2019
Inplant training in chennai
internship for eee students
free internship in chennai
eee internship in chennai
internship for ece students in chennai
inplant training in bangalore for cse
inplant training in bangalore
ccna training in chennai

TIC Academy said...

Wonderful Testing blog with lots of useful information..
QTP Training in Chennai | Selenium Training in Chennai | Software Testing Training in Chennai

sona roy said...

Thanks for sharing wonderful blog. Looking for seo company Service for your website? top seo company in Chennai provides the best Seo Services and whole digital marketing services.

digital marketing agency in chennai |digital marketing company in chennai |best seo company in chennai |seo company in velachery |top seo company in chennai |seo services in chennai |digital marketing in chennai |digital marketing in velachery

svrtechnologies said...

Thanks for sharing such an useful and informative stuff...

salesforce developer online training

sasi said...
This comment has been removed by the author.
svrtechnologies said...


That is nice article from you , this is informative stuff . Hope more articles from you . I also want to share some information about cognos tm1 training and cognos training

Salman said...

Effective blog with a lot of information. I just Shared you the link below for Courses .They really provide good level of training and Placement,I just Had Oracle CRM Classes in this institute,Just Check This Link You can get it more information about the Oracle CRM course.


Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

TIC Academy said...

Informative and nice blog post. Thanks for this wonderful Post.
SAP Training in Chennai
AWS Training in Chennai
Hardware and Networking Training in Chennai
QTP Training in Chennai
CCNA Training in Chennai

saran said...

"It is actually a great and helpful piece of information. I am satisfied that you simply shared this helpful information with us. Please stay us informed like this. Thanks for sharing.
Digital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery

"

divya said...

I appreciate your efforts because it conveys the message of what you are trying to say. It's a great skill to make even the person who doesn't know about the subject could able to understand the subject . Your blogs are understandable and also elaborately described. I hope to read more and more interesting articles from your blog. share more detais.
Ai & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai

Venkatesh CS said...

Thanks for sharing valuable information.
hadoop online training in chennai
hadoop online training
best hadoop certification online
hadoop online certification
hadoop training online
hadoop online classes
hadoop online course Chennai
hadoop online training Chennai
hadoop online learning
hadoop online courses
best hadoop online training

Devi said...

Thanks for sharing such a wonderful blog. oracle training in chennai

Devi said...

Your blog is really nice and informative. Thanks for sharing this post. oracle training in chennai

venkateshj said...

We provide best Selenium training in Bangalore, automation testing with live projects. Cucumber, Java Selenium and Software Testing Training in Bangalore.
Online selenium training in India - KRN Informatix is a leading Selenium Training Institute in Bangalore offering extensive Selenium Training
Online selenium training in India
Weekdays selenium training in bangalore
Weekend selenium training in bangalore
Weekend online selenium training
Java Selenium Automation Training in Bangalore
Online selenium training in India

Mohd Sharique said...

Excellent content! Thanks for sharing such a useful information.

Best Apache Spark Online Course
Apache Spark and Scala Online Training

Brad Litt said...

Let’s Create Pottery Mod Apk Today we are living in the Modern Data World. Yes, “SOFTWARE TESTING” is Very important in the real time world to find the defects made in the development phase. Software testing helps to grow your business in a better way.

Shahbaz Anjam said...



There’s certainly a lot to find out about this topic.
I like all the points you’ve made.

tubedigger crack
foxit reader
adobe xd cc crack
recuva professiona crack

Devi said...

Grab the extraordinary Oracle Course with PLSQL from Infycle Technologies, the best software training institute in Chennai. Infycle offers the Best Oracle PLSQL Training in Chennai, with various IT demanding courses such as Big Data, Python, DevOps, Selenium, Full-Stack development, etc., in complete hands-on practical training with professional tutors in the field. In addition to that, the mock interviews will be done for the candidates so that they can face the interviews with total confidence. To have all these within your hands, call 7502633633 for a free demo.Best Oracle PLSQL Training in Chennai | Infycle Technologies

aditya said...
This comment has been removed by the author.
Karthik said...

Blog detailing is meaningful. Thanks.
Learn Swift Online
Swift Online Course

INFYCLE TECHNOLOGIES said...

Some may stag in Interviews!!! OOPS!! More than 50% of students do this in their career. Instead, do Hadoop Training in Chennai at Infycle. Those students can easily clear this Interview session because more than 5 times at INFYCLE practicing mock-interview sessions, Hence students are Getting out of their interview fear.

ravi said...

thanks for sharing a nice blog keep posting like this if like more visit it https://snowflakemasters.in/

Cracksync said...


This is an excellent website. Continue to share useful information like this.
https://cracksync.com/naturalreader-professional-ultimate/

Mari said...

Hi, I am Mari. your blog is very nice. I appreciate you. Thank you for sharing us such a nice post. https://softhound.net/sylenth1-crack-download/

Anonymous said...

Hi, this was a nice informative & interesting blog to know about Software testing training in Chennai. thank you for sharing this blog. I have seen more interesting related to projects like verilog Projects for Mtech at Takeoff Projects.

Brolly said...

Nice blog post

Elvin said...

I recently stumbled upon this blog post while looking for information on NFT marketplace development services, and I was impressed by the insights shared here. I particularly appreciate the emphasis on finding a reliable and experienced NFT development service provider to ensure a secure and successful platform.

Speaking of which, I also checked out the link to NFTWIIZ's marketplace development services, and I must say I'm intrigued. Their website boasts an impressive portfolio of NFT projects across various industries, and their team seems to have the technical expertise and creativity to bring any NFT concept to life. I'm also glad to see that they prioritize security and scalability in their development process, which are crucial for any NFT marketplace.

Overall, I think NFTWIIZ could be a great option for anyone looking to create their own NFT marketplace or enhance an existing one. I'd love to hear from anyone who has worked with them and hear more about their experience. Thanks for sharing this valuable information!

NFT Marketplace Development service

aliya said...

In the bustling city center, the vibrant energy of the crowd was palpable. People hurried along the sidewalks, each with their own destination in mind, while street vendors called out, enticing passersby with the aroma of freshly cooked food. The towering skyscrapers, with their reflective glass facades, loomed overhead, casting intricate patterns of light and shadow on the streets below. Amid the urban hustle, a lone busker played a soulful tune on his guitar, momentarily captivating those who stopped to listen. The honking of cars and the distant hum of conversation created a symphony of urban life, a testament to the relentless pace and unending dynamism of the city. futemax

aliya said...

In the bustling city center, the vibrant energy of the crowd was palpable. People hurried along the sidewalks, each with their own destination in mind, while street vendors called out, enticing passersby with the aroma of freshly cooked food. The towering skyscrapers, with their reflective glass facades, loomed overhead, casting intricate patterns of light and shadow on the streets below. Amid the urban hustle, a lone busker played a soulful tune on his guitar, momentarily captivating those who stopped to listen. The honking of cars and the distant hum of conversation created a symphony of urban life, a testament to the relentless pace and unending dynamism of the city. 123movies

«Oldest ‹Older   401 – 436 of 436   Newer› Newest»