demo

View All Public Scripts Login to Run Script

Statement 1

create table richdemo(col1 number)

Table created.

Statement 2

insert into richdemo values (1)

1 row(s) inserted.

Statement 3

insert into richdemo values (2)

1 row(s) inserted.

Statement 4

select dbms_xmlgen.getxmltype('select * from richdemo') from dual

 
DBMS_XMLGEN.GETXMLTYPE('SELECT*FROMRICHDEMO')
<ROWSET>
 <ROW>
  <COL1>1</COL1>
 </ROW>
 <ROW>
  <COL1>2</COL1>
 </ROW>
</ROWSET>

DBMS_XMLGEN.GETXMLTYPE('SELECT*FROMRICHDEMO')
<ROWSET> <ROW> <COL1>1</COL1> </ROW> <ROW> <COL1>2</COL1> </ROW> </ROWSET>

Additional Information