XMLElement Generates Blank output in SQLPLUS
Hello,
I am new to XML.
I am running the following query on sqlplus and on TOAD on both i am getting a BLANK output. Is there any thing else i need to set.
select XMLElement("Name",user_name) from fnd_user fu where user_name = 'USMAN';
following is the extract from sqlplus screen
======================================================================================
SQL*Plus: Release 10.1.0.4.2 - Production on Wed Dec 12 14:47:13 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select XMLElement("Name",user_name) from fnd_user fu where user_name = 'USMAN';
0