ORACLE SQL insert xml record to sql table oracle sql - Net-Raft.com

Welcome aboard! We are happy you are here and wish you good net-raft!

Just a Web Code Solution
join us

how to insert xml record to sql table using oracle sql ?


 181

ORACLE SQL


0

create table xml_customers
(
record SYS.XMLType
);

insert into xml_customers values(
SYS.XMLType.createxml('<?xml version="1.0"?>
<CUSTOMER>
<CONTACT_NAME>JOHN BLACK</CONTACT_NAME>
<POSITION>DIRECTOR</POSITION>
</CUSTOMER>'));

By        
The power of the user (%)
62%

The most helpful ORACLE SQL solutions

add grant oracle sqladd grant oracle sqlORACLE SQL

Click to see more ...

  289     33
how to convert oracle sql date type to xml format ?how to convert oracle sql date type to xml format ?ORACLE SQL

Click to see more ...

  227     32
how to insert xml record to sql table using oracle sql ?how to insert xml record to sql table using oracle sql ?ORACLE SQL

Click to see more ...

  181     15
how to set grant to table using oracle sql ?how to set grant to table using oracle sql ?ORACLE SQL

Click to see more ...

  129     12
how to get xml document from oracle sql select ?how to get xml document from oracle sql select ?ORACLE SQL

Click to see more ...

  100     11
get recods plus 1 day oracle sqlget recods plus 1 day oracle sqlORACLE SQL

Click to see more ...

  169     11
Welcome aboard!
We are happy you are here and
wish you good net-raft!