Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about views
hi Raymond,
create view JJJJ as select decode(name,null,'Y','N') name,decode(age,0,'Y','N') age from TTTT;
Raymond Du wrote:
> I have a table
>
> name age
> ==== ====
> John 30
> Mike 35
> Albert 20
> David 45
> (NULL) 65
> (SPACE) 56
> Cathy 0
> Gina (NULL)
>
> I want to build a view and return something like
>
> name age
> ==== ====
> Y Y
> Y Y
> Y Y
> Y Y
> N Y
> N Y
> Y N
> Y N
>
> Thanks
>
> Raymond Du
> IDM Corp.
Received on Tue Jun 23 1998 - 00:00:00 CDT