Results 1 to 2 of 2
  1. #1
    jing-yi is offline Member
    Join Date
    May 2011
    Posts
    35
    Rep Power
    0

    Default 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

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default 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

  1. INSERT SQL statement problem
    By Johanis in forum New To Java
    Replies: 13
    Last Post: 11-09-2011, 04:33 PM
  2. Java Excel insert/update/delete/view
    By bdtuhin007 in forum JDBC
    Replies: 1
    Last Post: 11-04-2011, 03:44 AM
  3. Insert into statement HELP!
    By sdm in forum JDBC
    Replies: 1
    Last Post: 12-14-2010, 08:49 AM
  4. General Insert statement to DB
    By avisik in forum JDBC
    Replies: 1
    Last Post: 11-29-2010, 09:10 AM
  5. how to insert tables into JTextPane
    By osval in forum AWT / Swing
    Replies: 1
    Last Post: 07-29-2007, 10:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •