Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-00936: Missing Expression Error
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 Received on Wed Jun 28 2000 - 00:00:00 CDT