XML (XMLType) inside PL/SQL Oracle 9/10

By -
The XMLType is an OO XML aware data type. It can be used in columns or in PL/SQL just like VARCHAR2 or DATE. XMLType has member functions that allow access to data using XPath.

A quick example extracting a specific value from an XML varchar2 string:
DECLARE
v VARCHAR2(32000) := 'ABC';
x XMLType;
BEGIN
x := XMLType(v);
DBMS_OUTPUT.put_line(
x.extract('/DATA/LINE[1]').getStringVal()
);
DBMS_OUTPUT.put_line(
x.extract('/DATA/LINE[1]/text()').getStringVal()
);
END;

Comments

jAntoni said…
It was really very useful.
very simple and understandable complared to other examples in different sites.
11:35 PM
Post a Comment

Popular posts from this blog

Regular Expressions in .Net

By -
Regular Expressions Regular expressions have been widely popular in languages such as PERL and AWK and have been utilized for pattern matching, text manipulation and text searching. These languages are specifically is known for its advanced pattern matching features. Dot Net regular expressions are based on that of Perl and are compatible with Perl 5 regular expressions. To begin with, they are not as complex as they look, especially if you start experimenting with them. I would recommend that you download a tool such as Expresso (http://www.ultrapico.com/), to become familiar with regular expressions. Regular Expression Elements Some of the commonly used regular expression elements are: ^ Matches start of input $ Matches end of input . Matches any character except new line | OR * Match the preceding expression 0 or more number of times + ...
Read more

XML documentation in Visual Basic.NET applications

By -
By default VB.Net in VS.net is missing support for automated generation of the documentation from with in the source, Like Recommended Tags for Documentation Comments . Here 'VBCommenter' PowerToy from the Got Dot Net Web site can help us. With VBCommenter plug-in, they can create XML documentation as they are writing code. To use this facility, it's first necessary to install VBCommenter. The download is a ZIP file that includes a standard Setup.exe file with an accompanying .msi file; it's trivial to unpack and install and should take no more than two minutes. Configure VBCommenter settings from the Tools VBCommenter Options menu. Here, make sure the checkboxes for both "Create .xml files when projects are built" and "Insert XML comments in source" are checked. Once the plug-in is running and configured, simply key three apostrophes into the Start Page for any class definition, property, member variable, or method. Because documenting as you...
Read more

MSDN TV Episode talks about "Data Access in ASP.NET 2.0"

By -
MSDN TV: Data Access in ASP.NET 2.0 : Data Access in ASP.NET 2.0 Bradley Millington shows how to build a data-driven Web site in ASP.NET 2.0 and Visual Studio 2005. Learn how to build a database from scratch using Visual Studio built-in support for SQL Server 2005 Express, then retrieve and render the database contents using the new data controls in ASP.NET. -------------------------------------------------------------------------------- Hammad Rajjoub, MVP (Windows Server System - XML Web Services), User Group Leader - Dot Net Wizards (http://dotnetwizards.blogspot.com), Chariman UG Relations Committee (http://www.inetapakistan.org), Member Speakers Bureau (http://mea.ineta.org)
Read more