Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Inserstatement
You cannot achieve this by one sql statement.
Instead you should consider use PL/SQL.
Make your own procedure or an anonymous PL/SQL block.
I would like to give you an example but you have to tell more about your
problem, like the update should be done based on a relation between those 2
tables... and furthermore it's an insert or an update what you were talking
about?
If you want just an insert you can use something like:
INSERT INTO X
(<field_in_X>)
SELECT <field_in_P> FROM P
Regards
Iulian
-----Original Message-----
Sent: Tuesday, November 27, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
How can I update one field in table X
from another table, table P. Table P have 5 different fields but only one of
them should be used to update table X.
Give me an example on a sql statement for this.
Sincerely
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Roland.Skoldblom_at_ica.se
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Iulian.ILIES_at_mobil-rom.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 27 2001 - 06:55:58 CST
![]() |
![]() |