am trying to update a column with 0-zero in the front but not taking
978485May 9 2013 — edited May 10 2013hi all ,
Help is greatly appreciated,
am trying to udpate a coulmn on a table like below ,but its not taking the zero -0 in the oclumn.
update xace.pet
set petsplace='05000'
where place='NY';
After update when i select the tabel for this particaular entry its returning petsplace =5000 ,its not taking the 0-zero in the front.
The table structure from toad when i decsribe using F4.
petsplace- datatype number(8) , Num distinct -4 , Density -.25
Can anyone please let me know why its not taking the 0-zero even though its given in quotes.
Please let me know if any information is needed.