Oracle
王小王.
聚沙成塔
展开
-
oracle锁表与kill session
1、锁表查询select t2.username, t2.sid, t2.serial#, t3.object_name, t2.OSUSER, t2.MACHINE, t2.PROGRAM, t2.LOGON_TIME, t2.COMMAND from v$locked_obj...原创 2018-04-12 17:29:01 · 1406 阅读 · 0 评论 -
Oracle固定小数位长度,不足用0补齐
SQL> SELECT CAST(123 AS NUMBER(10,6)) FROM dual;CAST(123ASNUMBER(10,6))----------------------- 123.000000CAST函数:数据类型转换CAST( 列名/值 AS 数据类型)原创 2018-07-04 11:05:02 · 6575 阅读 · 0 评论