| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> 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 - 00:00:00 CDT
 |
 |