Home » SQL & PL/SQL » SQL & PL/SQL » Inserting data using a view.
Inserting data using a view. [message #18722] Tue, 12 February 2002 05:59 Go to next message
Andrew Ford
Messages: 18
Registered: November 2001
Junior Member
I am wanting to insert data into more than 1 table.

Is there a way of doing this by creating a view? i.e. create view based on more than 1 table and then insert appropriate values into the view so that the base tables would also be populated.
Re: Inserting data using a view. [message #18724 is a reply to message #18722] Tue, 12 February 2002 06:25 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

i do not think it is possible.if view depends on more than one column , the there will be join operation.if join operation occurs in a view, view can not be inserted/updated...

cheers
pratap
Previous Topic: 'ignore = y ' still IMP-00019: row rejected due to ORACLE error 1
Next Topic: One URGENT problem with SQL
Goto Forum:
  


Current Time: Tue Sep 28 11:25:20 CDT 2021