SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XMLElement return null

Rosario VigilanteJun 26 2014 — edited Jun 26 2014

Hello

this is my first times I work with Xml data

I don't understand because this one following return null


SELECT XMLElement("Date", HIREDATE)  
FROM EMP

but This work

select dbms_xmlgen.getxml('select * from dept') from dual

Release 11.2.0.3.0

Thanks for any info in advance

This post has been answered by odie_63 on Jun 26 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 24 2014

Added on Jun 26 2014

6 comments

1,095 views