Very Computer

Hello !

I need to preform one insert into two tables.
Can I make somethink like that:

INSERT INTO Table1 t1, Table2 t2 ( t1.field1, t2.field2 )
VALUES ( 23, 34 )

On which Databasesystems does this work ?
I'm working with Oracle 8.05

Thanks
 neolynx

Sent via Deja.com http://www.deja.com/
Before you buy.

Can't do it.  Try:

INSERT INTO table1 (field1) values (23); INSERT INTO table2 (field2) values
(24);

as a multiple statement block, or wrap a transaction around the two inserts
if atomicity is needed:

BEGIN WORK;
INSERT INTO table1 (field1) values (23);
INSERT INTO table2 (field2) values (24);
COMMIT WORK;

Art S. Kagel

Quote:> On which Databasesystems does this work ?
> I'm working with Oracle 8.05

> Thanks
>  neolynx

> Sent via Deja.com http://www.deja.com/
> Before you buy.

You could make a stored procedure with 6 parameters
(table1,table1,field1,field2,value1,value2)

create or replace procedure do_insert (p_table1 in varchar2,...)
begin
 insert into p_table1 (p_field1) values (p_value1);
 insert into p_table1 (p_field1) values (p_value1);
end;

from pl/sql there's only one statement left:
do_insert(..,..,..,..);

or SQLplus:
exec do_insert(..,..,..,..);

Quote:> Hello !

> I need to preform one insert into two tables.
> Can I make somethink like that:

> INSERT INTO Table1 t1, Table2 t2 ( t1.field1, t2.field2 )
> VALUES ( 23, 34 )

> On which Databasesystems does this work ?
> I'm working with Oracle 8.05

> Thanks
>  neolynx

> Sent via Deja.com http://www.deja.com/
> Before you buy.