摘要：
1.分组函数--select max(tfi.expected_scale) max1,min(tfi.expected_scale) min1,to_char(avg(tfi.expected_scale), '9,999,999,999,990.99999') avg1 小数点后几位from t 阅读全文
摘要：
--查询被锁的表 select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id; --查看是哪个session引 阅读全文