SQL*Plus (MOSC)

MOSC Banner

XMLElement Generates Blank output in SQLPLUS

edited Dec 12, 2012 12:52AM in SQL*Plus (MOSC) 3 commentsAnswered ✓
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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center