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: Jerome Vitalis <vitalismanN0SP4M_at_gmail.com.invalid>
Date: Thu, 11 Jan 2007 14:51:46 +0100
Message-ID: <45a63fff$0$296$426a74cc@news.free.fr>


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? ;-) Received on Thu Jan 11 2007 - 07:51:46 CST

Original text of this message

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