trouble with insert

#21

sheldonlg schrieb:

Quote:

Duh! I found the answer. I cannot specify "VALUES". I should have
written:

insert into table2 (fld1, fld2, fld3)
(select fld1, fld2, fld3 from table1 where blah)

I am glad, you solved your problem, but maybe you will be interested to
notice, that similar semantics ( with values clause ) is possible for
multitable insert ( that can operate on one table as well) - something like

create table emp_short
as
select ename,empno
from emp where 1=2
;

insert all
into emp_short(ename,empno)
values(ename,empno)
select * from emp
;

http://download.oracle.com/docs/cd/B...4.htm#i2095116

Best regards

Maxim

#22

Maxim Demenko wrote:

Quote:

sheldonlg schrieb:

Duh! I found the answer. I cannot specify "VALUES". I should have
written:

insert into table2 (fld1, fld2, fld3)
(select fld1, fld2, fld3 from table1 where blah)

I am glad, you solved your problem, but maybe you will be interested to
notice, that similar semantics ( with values clause ) is possible for
multitable insert ( that can operate on one table as well) - something like

create table emp_short
as
select ename,empno
from emp where 1=2
;

insert all
into emp_short(ename,empno)
values(ename,empno)
select * from emp
;

http://download.oracle.com/docs/cd/B...4.htm#i2095116

Best regards

Maxim

Thank you. That is very interesting.

#23

Maxim Demenko wrote:

Quote:

sheldonlg schrieb:

Duh! I found the answer. I cannot specify "VALUES". I should have
written:

insert into table2 (fld1, fld2, fld3)
(select fld1, fld2, fld3 from table1 where blah)

I am glad, you solved your problem, but maybe you will be interested to
notice, that similar semantics ( with values clause ) is possible for
multitable insert ( that can operate on one table as well) - something like

create table emp_short
as
select ename,empno
from emp where 1=2
;

insert all
into emp_short(ename,empno)
values(ename,empno)
select * from emp
;

http://download.oracle.com/docs/cd/B...4.htm#i2095116

Best regards

Maxim

Thank you. That is very interesting.

#24

Maxim Demenko wrote:

Quote:

sheldonlg schrieb:

Duh! I found the answer. I cannot specify "VALUES". I should have
written:

insert into table2 (fld1, fld2, fld3)
(select fld1, fld2, fld3 from table1 where blah)

I am glad, you solved your problem, but maybe you will be interested to
notice, that similar semantics ( with values clause ) is possible for
multitable insert ( that can operate on one table as well) - something like

create table emp_short
as
select ename,empno
from emp where 1=2
;

insert all
into emp_short(ename,empno)
values(ename,empno)
select * from emp
;

http://download.oracle.com/docs/cd/B...4.htm#i2095116

Best regards

Maxim

Thank you. That is very interesting.

#25

Maxim Demenko wrote:

Quote:

sheldonlg schrieb:

Duh! I found the answer. I cannot specify "VALUES". I should have
written:

insert into table2 (fld1, fld2, fld3)
(select fld1, fld2, fld3 from table1 where blah)

I am glad, you solved your problem, but maybe you will be interested to
notice, that similar semantics ( with values clause ) is possible for
multitable insert ( that can operate on one table as well) - something like

create table emp_short
as
select ename,empno
from emp where 1=2
;

insert all
into emp_short(ename,empno)
values(ename,empno)
select * from emp
;

http://download.oracle.com/docs/cd/B...4.htm#i2095116

Best regards

Maxim

Thank you. That is very interesting.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

trouble with insert

comp.databases.oracle.misc comp.databases.oracle.misc

Re: trouble with insert - 07-13-2008 , 09:08 AM

Re: trouble with insert - 07-13-2008 , 10:14 AM

Re: trouble with insert - 07-13-2008 , 10:14 AM

Re: trouble with insert - 07-13-2008 , 10:14 AM

Re: trouble with insert - 07-13-2008 , 10:14 AM