Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: column aliases in views

Re: column aliases in views

From: Filipe David Borba Manana <fdmanana_at_cern.ch>
Date: Thu, 11 Jan 2007 15:12:07 +0100
Message-ID: <eo5gjn$d43$1@cernne03.cern.ch>


Jerome Vitalis wrote:
> Filipe David Borba Manana wrote:
>

>> Replacing accountname with 
>> NVL(get_value(hostname,'/system/accounting/name'), 'undefined') works, 
>> although is not very elegant.
>>

>
> Hadn't you read my answer which suggested to do so a long time ago? ;-)

Yes, and I tried it. I was just trying to figure out if there was a more elegant alternative :)
It seems there isn't any.

Many thanks,

Manana Received on Thu Jan 11 2007 - 08:12:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US