TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
0
)
Problem with population of DataGrid/ListView with DataSets.
How to catch Primary key exception ???