Re: SQL question: Find ColumnName when it's value is NULL?
From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Thu, 28 Jul 2011 12:59:19 -0700
Message-ID: <CACpWLjPM9-ThXZdhgJnUm-TLhseYCyUC=jAwcb=ydL-dpjxdMQ_at_mail.gmail.com>
select nvl(mycol,'MYCOL') from mytable;
Date: Thu, 28 Jul 2011 12:59:19 -0700
Message-ID: <CACpWLjPM9-ThXZdhgJnUm-TLhseYCyUC=jAwcb=ydL-dpjxdMQ_at_mail.gmail.com>
select nvl(mycol,'MYCOL') from mytable;
On Thu, Jul 28, 2011 at 10:48 AM, Anthony Ballo <anthony.ballo_at_onecall.com>wrote:
> Is it possible to return the column's name when the contents is NULL? I've
> looked at FInd_String but was wondering if someone had a (better) way?
>
>
> Thanks,
>
> Anthony
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 28 2011 - 14:59:19 CDT