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 - 07:11:42 CDT