Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00936: Missing Expression Error
"Hans" <hans.steijntjes_at_chello.nl> wrote:
>You made an error in the outer join condition.
>Rewrite the outer-join as follows:
>
> where EquipItem.EquipID = Equipment.EquipID and
EquipItem.ItemID
>=Feature.ItemID(*)
>
>Good luck,
>
>Hans Steijntjes
>
>
>
>
>"Arun Solleti" <asolleti_at_csee.usf.edu> schreef in bericht
>news:395A586E.57B22994_at_csee.usf.edu...
>> I am trying to create a view with outer join condition using
the
>> following code
>>
>> CREATE VIEW "VW_EQUIP_SEARCH1" AS select
>> EQUIPITEM.ITEMID, EQUIPITEM.RETURNDT, EQUIPITEM.STATUS,
>> EQUIPMENT.CATEGORY, FEATURE.DESCRIPTION
>> from EQUIPITEM, EQUIPMENT, FEATURE where
>> EquipItem.EquipID = Equipment.EquipID and EquipItem.ItemID =*
>> Feature.ItemID;
>>
>> The last condition which specifies outer join is
EquipItem.ItemID =*
>> Feature.ItemID
>>
>>
>> But when i use this statement it gives me an error
>> ERROR at line 5:
>> ORA-00936: missing expression
>>
>>
>> Suggests are appreciated
>>
>> Arun
>>
>>
>
>
>
>
Got questions? Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com
Received on Thu Jun 29 2000 - 00:00:00 CDT