How to Generate XML from the Oracle Database
Oracle provides plenty of XML generation methods, I’ll try to demonstrate two of them: SYS_XMLGEN and DBMS_XMLQUERY.
I’ll start with creating a simple table and fill it with sample data:
1 2 3 4 5 6 7 8 |
CREATE TABLE customers ( customer_name VARCHAR2 (30), phone VARCHAR2(11)); INSERT INTO customers VALUES ( 'GOKHAN', '5421000100' ); INSERT INTO customers VALUES ( 'JACK', '5426661010' ); INSERT INTO customers VALUES ( 'JHON', '5352004050' ); COMMIT; |
To be able to use SYS_XMLGEN, I’ll create an object to map our data:
1 2 3 |
CREATE OR REPLACE TYPE customers_map_type AS OBJECT ( customer_name VARCHAR2 (30), phone VARCHAR2(11)); |