Top "Xmltype" questions

Oracle Pl/SQL: Loop through XMLTYPE nodes

I have a XMLTYPE with the following content: <?xml version="1.0"?> <users> <user> <name&…

xml oracle plsql xmltype

Add column in Oracle table

I'm trying to add an XMLType column into a table, but it returns an error. Why? This is the query: …

sql oracle xmltype

Oracle extract values from xmltype

This is the code I am currently using: SET serveroutput ON CREATE OR REPLACE PROCEDURE test_proc(i_xml varchar2) …

oracle plsql extract xmltype

Strange Oracle XMLType.getClobVal() result

I use Oracle 11g (on Red Hat). I have simple regular table with XMLType column: CREATE TABLE PROJECTS ( PROJECT_ID …

oracle xmltype

What is a good alternative to Toad for Mac OSX?

I am looking for an alternative to Oracle's Toad for Mac OS X. I currently use this for work on …

sql macos oracle xmltype

How to change character set of the XMLTYPE variable?

I'm currently having non-utf-8 DB but I need to produce XMLType variable with utf-8 encoding. I'm having a workaround but …

oracle plsql blob xmltype

Extract specific value from CLOB (containing XML) while creating one delimited string per row of a table. CLOB value may be null on some rows

Some Context: The DB is Oracle. I am trying to create one delimited string per row of a table. Some …

sql xml oracle clob xmltype

How to get first element by XPath in Oracle

In my Oracle db I have records like this one: <ROOT> <Event> <Type>sldkfvjhkljh&…

sql xml oracle xpath xmltype

Select xpath values as separate rows in Oracle SQL

I need to select some values from an XML stored in a CLOB column in an Oracle database. The best …

sql xml oracle xpath xmltype

Insert xml into XmlType field

I have this table in Oracle 11g: create table tmp_test_xml ( name_xml varchar2(4000), file_xml xmltype ); At this …

sql oracle insert oracle11g xmltype