Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is this possible NULL AS Placeholder
Yes, it is possible, but your NULL corresponds to
angebotsstr.angebotsstruktur, so it must nave same
datatype (wich I don't khow). For example,
if it is VARCHAR2, use to_char(NULL) instead of NULL.
Eric Euerlings wrote in message <71p1po$ngt$1_at_bw107zhb.bluewin.ch>...
>create or replace view
...
> as select angebot_teilangebot.mandant,
...
> null // IS THIS POSSIBLE IN ORACLE ?
> from angebot
..
> union select angebot.mandant,
...
> angebotsstr.angebotsstruktur
> from angebot , angebotsstr
Received on Wed Nov 04 1998 - 05:06:16 CST