关于一个oracle函数的问题? select to_char(a) from a; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select to_char(a) from A 12:38:52 SQL> select to_char(123.123) from dual;TO_CHAR-------123.123实际:10012:39:03 SQL> select to_char(123.123,9999.9) from dual;TO_CHAR------- 123.1实际:3012:39:21 SQL> select to_char(123.123,9999.99999) from dual;TO_CHAR(123----------- 123.12300实际:3012:39:33 SQL> 补充:SQL> select to_char(123) from dual;TO_CHAR(123)------------123 你写的很对啊Select TO_char(a) From A select to_char(a) from a; ora11g出现与内存相关的一些问题 java 存储过程 编码 找Oracle Database 11g源码? oracle 备份 数据库导入imp要求输入口令的问题 oracle 8.1.7.0.0 enterprise manager 是什么? 8.1.7的数据库备份能导入到8.1.5的库中去马? 这个存储过程通不过 子查询的结果能否再次引用? oracle 安装后提示ora-01031:insufficint privileges oracle中imp问题请问大虾! 函数可以返回个值,触发器能返回个值么?
select to_char(a) from A
-------
123.123实际:100
12:39:03 SQL> select to_char(123.123,9999.9) from dual;TO_CHAR
-------
123.1实际:30
12:39:21 SQL> select to_char(123.123,9999.99999) from dual;TO_CHAR(123
-----------
123.12300实际:30
12:39:33 SQL>
SQL> select to_char(123) from dual;TO_CHAR(123)
------------
123
Select TO_char(a) From A