Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about views
On 22 Jun 1998 14:10:01 -0700, "Raymond Du"
<rdu_at_idmcorp.com> wrote:
>I want to build a view and return something like
>
>name age
>==== ====
>Y Y
<snip>
You could try:
CREATE VIEW put_name_here AS
SELECT decode (name, null,'N','Y') name,
decode(age,null,'N','Y') age
FROM your_table;
Received on Tue Jun 23 1998 - 18:43:46 CDT