OraFAQ Forum: SQL & PL/SQL » Join in Insert

Home » SQL & PL/SQL » SQL & PL/SQL » Join in Insert

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Join in Insert [message #584896]

Mon, 20 May 2013 07:01

Taha
Messages: 8
Registered: February 2009
Location: Karachi

Junior Member

Hi

I am trying to insert records in multiple tables. I know how to view data using joinig, but unable to understand how to insert records in multiple tables using Joining. I searched it on net, but didn't find much. I have also tried to write a code, but it is not working, I have seen some examples on different websites where people are using SELECT in INSERT statement for joining. Kindly tell me the correct Syntax to INSERT record in Multiple tables.

Insert into library_users, library_users_info
(library_users.username, library_users.password, library_users_info.address, library_users_info.phone_no) VALUES (...)

[Updated on: Mon, 20 May 2013 07:02]

Report message to a moderator

Re: Join in Insert [message #584899 is a reply to message #584896]

Mon, 20 May 2013 07:06

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You can't do that. INSERT works with a single table only (unless you insert into a view, whose INSTEAD OF triggers do additional job and insert into different tables). Though, you could use INSERT ALL, such as

insert all
  into library_users (username, password) values ('lf', 'pwd')
  into library_users_info (address, phone_no) values ('croatia', '12345')
select * from dual

Report message to a moderator

Re: Join in Insert [message #584901 is a reply to message #584896]

Mon, 20 May 2013 07:09

Solomon Yakobson
Messages: 3305
Registered: January 2010
Location: Connecticut, USA

Senior Member

Did you read documentation? Look for multi table insert under INSERT

SY.

Report message to a moderator

Previous Topic:	Understanding Primary Key/Composite Key
Next Topic:	utl_file error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 10 02:51:57 CDT 2025