This is just great....didnt know about this till now....

Thanks Sachi...

Vikas Bhat
Senior Software Engineer,
FBSI Pvt Ltd.,
Embassy Golf Links Business Park,
Intermediate Ring Road,
Bangalore - 560071
Email - vikas.[Email address protected]
Ph:91-80-56916482
Mob:91-9845589149
Those who aspire for the light of sun; need to bear its heat.

Any comments or statements made in this email are not necessarily those
of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity
Investments group companies. The information transmitted is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. If you have received this in
error, please contact the sender and delete the material from any
computer. All e-mails sent from or to Fidelity Business Services India
Pvt. Ltd. may be subject to our monitoring procedures.



-----Original Message-----
From: Sachidananda_T
[mailto:oracledba-ezmlmshield-x73227432.[Email address protected]
Sent: Thursday, September 29, 2005 9:43 AM
To: LazyDBA Discussion
Subject: RE: Insert problem


Hi Vikas,

Try this,

insert into t1 values((select 1 from dual));

This should work.

One more example

insert into dept(dno,dname) values(10,'purchasing');

insert into emp(empno,dept)
values(10,(select dno from dept where dname='purchasing'))

Regards
Sachi

-----Original Message-----
From: Bhat Vikas
[mailto:oracledba-ezmlmshield-x57980358.[Email address protected]
Sent: Thursday, September 29, 2005 9:38 AM
To: LazyDBA Discussion
Subject: RE: Insert problem

Hi Salahuddin,

I know this but the example given below was for Sachi, because he said
in his reply that putting select inside a values clause of insert works
in Oracle 9i. Since I couldn't get the thing working, I thought maybe I
was missing something here.

Thanks and regards,
Vikas Bhat
Senior Software Engineer,
FBSI Pvt Ltd.,
Embassy Golf Links Business Park,
Intermediate Ring Road,
Bangalore - 560071
Email - vikas.[Email address protected]
Ph:91-80-56916482
Mob:91-9845589149
Those who aspire for the light of sun; need to bear its heat.

Any comments or statements made in this email are not necessarily those
of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity
Investments group companies. The information transmitted is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. If you have received this in
error, please contact the sender and delete the material from any
computer. All e-mails sent from or to Fidelity Business Services India
Pvt. Ltd. may be subject to our monitoring procedures.



-----Original Message-----
From: Salahuddin
[mailto:oracledba-ezmlmshield-x65995950.[Email address protected]
Sent: Wednesday, September 28, 2005 6:30 PM
To: LazyDBA Discussion
Subject: RE: Insert problem


Try this

insert into t1(a,b) select 1, 2 from dual;


Regards,
Salahuddin






Oracle LazyDBA home page