OraFAQ Forum: SQL & PL/SQL » insert float value in to Number column

Home » SQL & PL/SQL » SQL & PL/SQL » insert float value in to Number column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

insert float value in to Number column [message #143776]

Sat, 22 October 2005 05:59

mymot
Messages: 225
Registered: July 2005

Senior Member

Hi,

I want to insert float value into integer column type.

DESC N;

id number(38)

insert into n values(33.3);

i have tried

insert into o values(cast(33.3 as float));

but inserting only 33

any suggestons...

thanks

Report message to a moderator

Re: insert float value in to Number column [message #143777 is a reply to message #143776]

Sat, 22 October 2005 06:08

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

hi,

not possible ,if the column has data.if it's empty then
user the alter table clause


regards,

Report message to a moderator

Re: insert float value in to Number column [message #143778 is a reply to message #143776]

Sat, 22 October 2005 06:11

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

hi,

correction .......it's possible .

alter table <table_name> modify <column_name> number

regards,

Report message to a moderator

Re: insert float value in to Number column [message #143782 is a reply to message #143778]

Sat, 22 October 2005 07:57

mymot
Messages: 225
Registered: July 2005

Senior Member

thanks, thats what i did.

cheers

Report message to a moderator

Previous Topic:	PL/SQL question
Next Topic:	Question regarding bulk loading.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 09 05:03:06 CDT 2025