Re: When to use Updateable View ?

krislioe_at_gmail.com wrote:
> Hi ,
>
> I have questions about updateable View :
>
> 1) when is it appropriate to use it (instead of the underlying
> table/tables) ?
>
> 2) what is the performance impact ?
>
> Thank you very much,
> xtanto

Depending on the view you may pay a small price for the view.

The appropriate usage is when you want to separate the schema being accessed by an application, or users, from the schema with the tables. And when you want to hide some columns from end-users.

-- 
Puget Sound Oracle Users Group