HI I have a requirement
i would like to create a view based on a column value in a schema.
eg. i have a common field "updated_flag" in all tables.
if the flag is updated to 'Y" then would like to get the information related to that employee
eg.
depatment and employee are the tables and salary and commission are other child tabls.
i want to see the complete information of the 4 tables when the updated_flag = 'Y"
even only the child updated also should get the data
like the view should contain where flag='Y'
i am trying to get the information from cols table.
but no luck.
empno deptno ename sal comm updated_flag updated_date
101 10 test1 1000 100 'Y' last updated
thanks.