Results 1 to 2 of 2
- 12-05-2011, 11:03 AM #1
Member
- Join Date
- May 2011
- Posts
- 35
- Rep Power
- 0
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
- 12-05-2011, 01:34 PM #2
Moderator
- Join Date
- Apr 2009
- Posts
- 10,481
- Rep Power
- 16
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.
Similar Threads
-
INSERT SQL statement problem
By Johanis in forum New To JavaReplies: 13Last Post: 11-09-2011, 03:33 PM -
Java Excel insert/update/delete/view
By bdtuhin007 in forum JDBCReplies: 1Last Post: 11-04-2011, 02:44 AM -
Insert into statement HELP!
By sdm in forum JDBCReplies: 1Last Post: 12-14-2010, 07:49 AM -
General Insert statement to DB
By avisik in forum JDBCReplies: 1Last Post: 11-29-2010, 08:10 AM -
how to insert tables into JTextPane
By osval in forum AWT / SwingReplies: 1Last Post: 07-29-2007, 09:11 AM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks