Originally posted by Parameswaran Thangavel: My requirement is i need to filter out the data based on the user input, and i think this cant be acheived in view, since view didn't support the parameter.

A view supports parameters unless we are talking about different things. You create the view once to abstract away some complexity. Then you do the query as if it were a normal table.

You may want to post some code showing what you are trying to do that isn't supported. Then we could give more concrete comments.