Oracle The accumulation of

1            use To_char() Convert numbers with decimals .  for example :0.125  Take two decimal places .

To_char(0.125,’FM990.99’)   -> 0.13

notes :  format FM990.99    FM:  Go to space ; 990:  Integral part , Maximum 7 position , More than #.  because  9 On behalf of the digital , If it does not exist or is zero, it is treated as a space , So the place before the decimal is 0 Prevent emergence .13 The situation of .

Oracle Accumulated more related articles

  1. oracle The accumulation continues

    Select the date of the day select * from test_table where to_char(datetime, 'yyyy-mm-dd')=to_char(sysdate,'yyyy-mm-d ...

  2. Oracle----SQL Sentence accumulation (Oracle Import dmp file )

    Oracle----SQL Sentence accumulation (Oracle Import dmp file ) Oracle SQL PL   Import dum file 1. database DBA jurisdiction : Be careful : This is in cmd Enter... Directly from the command line , There is no need to enter Oracl ...

  3. [ Strongly recommend ]ORACLE PL/SQL Programming explanation 7 ： Package creation and application ( Cleverness lies in learning , Genius is the accumulation of ！)

    original text :[ Strongly recommend ]ORACLE PL/SQL Programming explanation 7 : Package creation and application ( Cleverness lies in learning , Genius is the accumulation of !) [ Strongly recommend ]ORACLE PL/SQL Programming explanation 7 : Package creation and application ( Cleverness lies in learning , God ...

  4. oracle Common function accumulation

    --oracle Common function accumulation -- --1. String length :LENGTH , grammar : CONCAT(string) -- Example select LENGTH('AA_BB') from dual;-- result :5 - ...

  5. Database related knowledge accumulation （sqlserver、oracle、mysql）

    Database related knowledge accumulation (sqlserver.oracle.mysql) 1. sqlserver : Disconnect all connections : ( Restore database ) 1. database   Separate 2. USE master GO ALTER DAT ...

  6. Daily accumulation oracle relevant information

    about VARCHAR2 type , We need to make a trade-off between memory usage and efficiency . about VARCHAR2( length >=2000) Variable ,PL/SQL Dynamically allocate memory to store actual values , But for the VARCHAR2( length <2000 ...

  7. 【 turn 】oracle Some experience of database development

    1. Not to install Oracle Customer connection Oracle 8 Methods    Please copy the following file to the directory where the running file is located One .ODBC Dynamic library  : ctl3d32.dll msvcrt40.dll odbc16gt.dll odbc ...

  8. Oracle Database common settings

    1. stay oracle In previous versions of , Your user name and password are case insensitive , But in 11g in , The case of the database default password is sensitive , Remove oracle Password capitalization sensitive settings : alter system set sec_ca ...

  9. ORACLE Basic knowledge accumulation

    establish ORACLE database , First use Sys The role of the account is dba Go into the database and , Then according to the table space of the created database , And then create characters , After creating the role, grant the table space permission to the role . SQL The statement is as follows : create temporary ...

Random recommendation

  1. JQuery Picture switch animation effect

    I'm lazy because of the blogger , So the page is rough , But it doesn't matter , Because I'm mainly talking about how to realize picture animation switching . Ideas : Everyone must have visited Taobao or some other websites , Generally, there will be the effect of image animation switching , How did that happen ? Blogger, what about me , The technology is not very ...

  2. google API Point connection

    This is simulated data , Used for testing , For the convenience of study Pop up messages are fixed , And the operation is not a write loop , For actual development  setInterval perhaps for To reduce redundancy . <!DOCTYPE html> < ...

  3. IOS Learning notes 25—HTTP Operation of the ASIHTTPRequest

    IOS Learning notes 25—HTTP Operation of the ASIHTTPRequest classification : iOS2012-08-12 10:04 7734 Human reading   Comment on (3)  Collection   report iosios5 The Internet wrapper Framework Sina Weibo A ...

  4. nohub command

    http://jingyan.baidu.com/article/335530daa4707f19cb41c3ef.html

  5. UML figure

  6. MySQL Optimize - One 、 Cache optimization

    body { font-family: Helvetica, arial, sans-serif; font-size: 14px; line-height: 1.6; padding-top: 10 ...

  7. Android Studio course 10-Intent Detailed use of

    Catalog 1. Intent starter 1.1. Intent Use of 1. start-up Activity 3. Deliver the broadcast 1.2. Intent type 1. Show Intent 2. Implicit Intent 2. structure Intent ...

  8. [ video ]K8 Flying cutter --WinRAR Remote Code Execution Exploit video

    [ video ]K8 Flying cutter --WinRAR Remote Code Execution Exploit video link :https://pan.baidu.com/s/17_0kgNsDejJS0hvgLiMD7A Extraction code :zkc2

  9. ( turn )Python Black magic --- asynchronous IO（ asyncio） coroutines

    from :http://www.jianshu.com/p/b5e347b3a17c?from=timeline Python Black magic --- asynchronous IO( asyncio) coroutines author   human world   Focus on 201 ...

  10. yii2 Detailed explanation of database operation （ Reprint ）

    To start using a database, you need to configure the database connection component first , By adding db Component to application configuration implementation (" The basis of " Web The application is config/web.php),DSN( Data Source Name ...