You don't need VPD for that -- just create a view...
create or replace view tbl_res_contact_v
select name, dob, decode(status,'',story,'') story, address
Then, use permissions to prevent people from querying the table and
leave only the view available.
Hope this helps...
Sanjay Mishra wrote:
can somebody help in VPD setup. I had a table with 5 column and
I want to hide 2 column based on one Column named status. Here is
I want to hide the data for story from all user when status is
other than NULL.
Be a better friend, newshound, and know-it-all with
Try it now.