Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is this possible NULL AS Placeholder

Re: Is this possible NULL AS Placeholder

From: Grinberg L. <leon_at_grant.kharkov.ua>
Date: Wed, 4 Nov 1998 13:06:16 +0200
Message-ID: <71pcci$cp@grant.grant.UUCP>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US