Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 17, 2012 12:41 PM by
NULL option of column command - ignore word after space in string
May 16, 2012 8:08 PM
I'm quit new to Oracle and SQL world.
building simple SQL/Plus report through SQL Developer enviroment:
I'm trying to use NULL option of COLUMN comand to output a meaningful string instead null.
But, any word after space in string.
Followings are what I wrote on worksheet and excute 'Run Script'.
COLUMN firedate NULL 'active';
COLUMN mentorid NULL 'no mentor';
select lastname, firstname, mentorid, firedate from members;
refer to line (COLUMN mentorid NULL 'no mentor';) the out put for the MentorId, display word no and ignore any word after space which is here word mentor.
SqL Developer ver. 3.1.07.
Oracle database 10g Express edition (10.2.0.1.0)
This content has been marked as final.
Show 1 reply
Re: NULL option of column command - ignore word after space in string
May 17, 2012 12:41 PM
in response to
SQL Developer is still not 100% SQL Plus compatible. It may be that this isn't implemented properly yet.
Does it work in SQL Plus?