Is that possible to write an insert statement into a view from mutli-tables?
A little bit stupid to post this question here. But I face this problem when perform in java/jdbc code.
Using oracle,
I am able to write an insert statement into a view that is constructed from one table.
My question is,
Is that possible to write an insert statement into a view that is constructed from multi tables?
Regards,
Jing-yi
Re: Is that possible to write an insert statement into a view from mutli-tables?
From here (the "Notes on Updatable Views" section):
"Each column in the view must map to a column of a single table."
There is a bit on updatable join views there as well, though it limits you to affecting a single table.