Home » SQL & PL/SQL » SQL & PL/SQL » Round values in a table
Round values in a table [message #352607] Wed, 08 October 2008 09:54 Go to next message
shrad2001
Messages: 20
Registered: September 2008
Location: faridabad
Junior Member
Thanks
a lot
it works really

now you are solving my problem so i want to share my one problem with u

i want to round the number that are stored in a table permanently
,i know round function but it works only for select statements
but i want command to rounds salary of employee stored in table

plssss
help me on my this trouble

thanks
shraddha
Re: Round values in a table [message #352693 is a reply to message #352607] Thu, 09 October 2008 00:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Split this topic off of a non-relevant thread.
Please do not continue other threads with off-topic questions.
Re: Round values in a table [message #352707 is a reply to message #352607] Thu, 09 October 2008 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use IM speak, OraFAQ Forum Guide.

Use UPDATE.

Regards
Michel
Re: Round values in a table [message #352708 is a reply to message #352607] Thu, 09 October 2008 01:34 Go to previous message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
u can use this function in UPDATE statement as well.
Previous Topic: help in SQL query to find the required row
Next Topic: count columns in table in sql
Goto Forum:
  


Current Time: Mon Dec 05 19:27:04 CST 2016

Total time taken to generate the page: 0.06367 seconds