问题起源
我们在数据库中存储了利率等信息是小于1的查询出结果后直接转换为字符串,这时候就有问题了比如0.5取出来后变成.5
这时候放到前端显得不伦不类。
解决
to_char 修改数字的格式,
常用的集中情况如下
SELECT 1, TO_CHAR(.08,'fm999999999990.00'), '小数格式化' FROM dual
UNION ALL
SELECT 2,TO_CHAR(0,'fm999999999990.00') , '0' FROM dual
UNION ALL
SELECT 3, TO_CHAR(1.236,'fm999999999990.00') , '超出位数四舍五入' FROM dual
UNION ALL
SELECT 4, TO_CHAR(1999,'fm999999999,990.00') ,'金额格式化,取出后不能用于计算了' FROM dual
UNION ALL
SELECT 5, TO_CHAR(199,'fm90.00'), '数字过大变成####' FROM dual
UNION ALL
SELECT 6, TO_CHAR(199,'9990.00'), '不加fm查询结果前面有空格' FROM dual
SightCare formula aims to maintain 20/20 vision without the need for any surgical process. This supplement is a perfect solution for people facing issues as they grow older. https://sightcare-web.com/
WeJiJ is here to help get you the best gaming setup, gaming PC and guide you through the games you like to play with news, reviews and guides. https://wejij.com/
Find the latest technology news and expert tech product reviews. Learn about the latest gadgets and consumer tech products for entertainment, gaming, lifestyle and more. https://axget.com/
Easier WWW is a leading technology site that is dedicated to produce great how-to, tips and tricks and cool software review. https://easierwww.com/
buy discount levitra
KeraBiotics is a meticulously-crafted natural formula designed to help people dealing with nail fungus. This solution, inspired by a sacred Amazonian barefoot tribe ritual https://kerabiotics-web.com/
FitSpresso is a natural dietary supplement designed to help with weight loss and improve overall health. It contains ingredients that have been studied clinically, which work together to promote healthy fat burning and enhance your metabolism! https://fitspresso-web.com/
Nagano Lean Body Tonic is a groundbreaking powdered supplement crafted to support your weight loss journey effortlessly. https://naganotonic-try.com/
Sugar Defender is a natural supplement that helps control blood sugar levels, lower the risk of diabetes, improve heart health, and boost energy. https://sugardefender-web.com/
– Shoot MASSIVE Loads For An Amazing Finish! https://semenax-try.com/
ZenCortex Research’s contains only the natural ingredients that are effective in supporting incredible hearing naturally.A unique team of health and industry professionals dedicated to unlocking the secrets of happier living through a healthier body. https://zencortex-try.com/
BalMorex Pro is an exceptional solution for individuals who suffer from chronic joint pain and muscle aches. With its 27-in-1 formula comprised entirely of potent and natural ingredients, it provides unparalleled support for the health of your joints, back, and muscles. https://balmorex-try.com/
order levitra usa
FlowForce Max is an innovative, natural and effective way to address your prostate problems, while addressing your energy, libido, and vitality. https://flowforcemax-web.com/
TestRX™ is a bodybuilding supplement. It’s formulated with high-quality natural ingredients proven to boost natural testosterone and stimulate muscle growth. https://testrx-web.com/
CLINICALLY PROVEN* To Increase Semen Volume And Intensity https://semenax-try.com/
DuoTrim is an innovative weight loss supplement that utilizes the power of natural plants and nutrients to create CSM bacteria https://duotrim-us.com/
Sugar Balance is an ultra-potent blood sugar supplement that you can use to help control glucose levels, melt away fat and improve your overall health. https://sugarbalance-us.com/
PureLumin Essence is a meticulously-crafted natural formula designed to help women improve the appearance of age spots. https://pureluminessence-web.com/
Progenifix is designed to help maximize weight loss results using a mixture of natural, science-backed ingredients. The formula also has secondary benefits, including promoting overall wellness and vitality and assisting your immune system. https://progenifix-web.com/
Gut Vita™ is a daily supplement that helps consumers to improve the balance in their gut microbiome, which supports the health of their immune system. It supports healthy digestion, even for consumers who have maintained an unhealthy diet for a long time. https://gutvita-us.com/
The ProNail Complex is a meticulously-crafted natural formula which combines extremely potent oils and skin-supporting vitamins. https://pronailcomplex-web.com/https://pronailcomplex-web.com/
Protoflow is a prostate health supplement featuring a blend of plant extracts, vitamins, minerals, fruit extracts, and more. https://protoflow-web.com/
Boostaro is a dietary supplement designed specifically for men who suffer from health issues. https://boostaro-try.com/
Unlock the incredible potential of Puravive! Supercharge your metabolism and incinerate calories like never before with our unique fusion of 8 exotic components. Bid farewell to those stubborn pounds and welcome a reinvigorated metabolism and boundless vitality. Grab your bottle today and seize this golden opportunity! https://puravive-web.com/
Zoracel is an extraordinary oral care product designed to promote healthy teeth and gums, provide long-lasting fresh breath, support immune health, and care for the ear, nose, and throat. https://zoracel-web.com
The human body can continue to live thanks to the correct functioning of certain systems. If even one of these systems does not work properly, it can cause problems in human life. https://calmlean-web.com/
Zeneara is marketed as an expert-formulated health supplement that can improve hearing and alleviate tinnitus, among other hearing issues. https://zeneara-web.com/
GlucoBerry is one of the biggest all-natural dietary and biggest scientific breakthrough formulas ever in the health industry today. This is all because of its amazing high-quality cutting-edge formula that helps treat high blood sugar levels very naturally and effectively. https://glucoberry-web.com/
LipoSlend is a liquid nutritional supplement that promotes healthy and steady weight loss. https://liposlend-web.com/
asacol online pharmacy
PotentStream is designed to address prostate health by targeting the toxic, hard water minerals that can create a dangerous buildup inside your urinary system It’s the only dropper that contains nine powerful natural ingredients that work in perfect synergy to keep your prostate healthy and mineral-free well into old age. https://potentstream-web.com/
Lasixiv provides news and analysis for IT executives. We cover big data, IT strategy, cloud computing, security, mobile technology, infrastructure, software and more. https://lasixiv.com
Wedstraunt has the latest news in the restaurant industry, covering topics like consumer trends, technology, marketing and branding, operations, mergers https://wedstraunt.com
Sisanit provides in-depth journalism and insight into the news and trends impacting corporate counsel. https://sisanit.com/
Marketing Dive provides in-depth journalism covering the most impactful news shaping the marketing industry. We cover topics like social media, video marketing, mobile, data and analytics, technology, and more. https://centralhp.com
Sugar Defender is the rated blood sugar formula with an advanced blend of 24 proven ingredients that support healthy glucose levels and natural weight loss. https://smithsis.com
Sugar Defender is the rated blood sugar formula with an advanced blend of 24 proven ingredients that support healthy glucose levels and natural weight loss. https://mariscosleomar.com/
sugar defender: https://seahorsesoap.com/
sugar defender: https://kandicandles.com/
sugar defender: https://cmymorgans.com/