February 25, 2007

Single table row to XML CLOB using DBURITYPE

Filed under: dburitype, example, PL/SQL, pl/sql code — Michael Moore @ 5:52 pm
set long 2200

-- PORTAL_NAME is a unique column of table TX_PORTAL in the QSN_APP schema

SQL> select (dburitype.createuri('/QSN_APP/TX_PORTAL/ROW[PORTAL_NAME="MORTGAGE"]')).getclob() mydata from dual;

<?xml version="1.0"?>


  1. Is there a way to do this without the ROW element added ?? I used your example (works great), but I can’t have the ROW element.

    thanks jim

    Comment by Jim — December 18, 2007 @ 6:21 pm

  2. Jim,
    select replace(
    ‘ROW>’,’ABC>’) mydata from dual;

    Comment by Michael Moore — January 22, 2008 @ 11:44 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: