Re: SQL question: Find ColumnName when it's value is NULL?

  • From: Michael Moore <michaeljmoore@xxxxxxxxx>
  • To: anthony.ballo@xxxxxxxxxxx
  • Date: Thu, 28 Jul 2011 12:59:19 -0700

select nvl(mycol,'MYCOL') from mytable;

On Thu, Jul 28, 2011 at 10:48 AM, Anthony Ballo
<anthony.ballo@xxxxxxxxxxx>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
>
>
>

Other related posts: