sourcehoh

sourcehoh

  • NA
  • 18
  • 0

Filter Record from Oracle View Object

Apr 11 2005 11:22 PM
I had created a View object in Oracle and it is called VW_CUSTOMER_ALL and it is contain all the customer rows in my customer master table... So, in my program, I can call this view object by execute the SQL as below SELECT * FROM VW_CUSTOMER_ALL But it will return all the customer information to me.. So now my question is how can i filter the records before it return to my program ( let say the customerid > 100 )? I had tried to execute the segment as below SELECT * FROM VW_CUSTOMER_ALL WHERE CUSTOMERID >100 But I got a error message - "ORA-00904: Invalid column name" when I execute the segment... I confirm that I included the CustomerID field in my select list when I create the View in Oracle Can somebody help me regards of this ?? Thank you