如何限制具有特定条件的oracle查询

I want to know if there is a way to specify a condition on a table, I mean I need to restrict queries under certain conditions such as status so that I don't have to rewrite the status condition within all the select queries that I already have in my application.I want to know if there is a way to specify a c