Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: id <> '2'
"mike" <hillmw_at_charter.net> wrote in message
news:1127340859.792926.179230_at_g49g2000cwa.googlegroups.com...
> nvl works great!!!
>
> btw, the id is the user who created the record and we had people that
> wanted to put some legacy data in so we have no earthly idea who
> created them.
>
> Thanks,
> Mike
>
i'd suggest renaming the column to something more descriptive, such as CREATE_BY_ID ++ mcs Received on Wed Sep 21 2005 - 19:43:20 CDT