Filter Record from Oracle View Object
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