All Forums Database
Rohit Ranjan 20 posts Joined 05/12
15 Nov 2014
Unable to insert

Hi
I am trying to insert data in a particular column but its not working

 

 

insert into emp(hire_date)

values(2009-03-18)

where eno= 2

 

Thanks,

Rohit

dnoeth 4628 posts Joined 11/04
16 Nov 2014

Hi Rohit,
Insert adds new rows, but this looks like you want to update an existing row:

update emp
set hire_date = date '2009-03-18'
where eno= 2

 

Dieter

Rohit Ranjan 20 posts Joined 05/12
16 Nov 2014

Thanks Dieter

You must sign in to leave a comment.