[20211220]sqlplus简单计算器.txt

[20211220]sqlplus简单计算器.txt --//看了tpt包calc.sql脚本,他要求输入3个参数,计算出10进制以及16进制结果. --//但是他的脚本比较灵活支持10进制以及16进制数字的输入: --//例子: SCOTT@book> @ ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production SCOTT@book> @　calc 10 + 4                                 DEC                  HEX ----------------------------------- --------------------                           14.000000                    E SCOTT@book> @　calc 0x10 + 4                                 DEC                  HEX ----------------------------------- --------------------                           20.000000                   14 SCOTT@book> @　calc x10 + 4                                 DEC                  HEX ----------------------------------- --------------------                           20.000000                   14 --//我自己写一个简单一点的输入10进制,算出10进制,16进制的结果.注意输入参数中间不能有空格。 $ cat calcx.sql COL value  new_value newvalue COL calc_dec HEAD "DEC" FOR 999999999999999999999999999.999999 COL calc_hex HEAD "HEX" FOR A20 JUSTIFY RIGHT set termout off select &1 value from dual; set termout on select &newvalue calc_dec , TO_CHAR (&newvalue, 'FM0xxxxxxxxxxxxxxx') calc_hex from dual ; --//测试: SCOTT@book> @calcx 120/12                                 DEC                  HEX ----------------------------------- --------------------                           10.000000 000000000000000a SCOTT@book> @calcx power(2,10)+1                                 DEC                  HEX ----------------------------------- --------------------                         1025.000000 0000000000000401 --//我以前从网上抄来一个bash计算器,自己修改一下,定义成函数.看看在sqlplus里面是否支持bash函数调用. --//使用bc计算器，里面函数不能使用圆括号，使用中括号代替。 --//测试不行。修改成shell。 # cat //usr/local/bin/== # /bin/bash # simple calc in="$(echo "$@" | sed -e 's/\[/(/g' -e 's/\]/)/g')"; echo $in | bc -lq | tr -d '\n\\\r' | sed -e "s/\.\([0-9]*[1-9]\)0\+$/.\1/" -e "s/\.0\+$//" echo SCOTT@book> host == "scale=4;4/3" 1.3333 --//有分号要加引号才行. SCOTT@book> host == 2^240 1766847064778384329583297500742918515827483896875618958121606201292619776 --//在bc下执行出现折行情况. $ echo 2^240 | bc -lq 17668470647783843295832975007429185158274838968756189581216062012926\ 19776 SCOTT@book> host == "scale=100;a(1)*4" 3.1415926535897932384626433832795028841971693993751058209749445923078164062862089986280348253421170676 --//PI小数点100位.