oracle
cover_power
这个作者很懒,什么都没留下…
展开
-
dba_segments 查看表使用的容量
-- 查看表空间 select sum(bytes)/1024/1024 M from dba_segments where owner='CDRQUERY' and segment_name='GPRS270_201310';原创 2013-12-02 16:54:38 · 1631 阅读 · 0 评论 -
查看表空间的容量
set line 300 pages 2000 Select d.tablespace_name, Space "Sum_space(M)", Blocks sum_blocks, Space - nvl(free_space, 0) "Used_space(M)", round((1 - nvl(free_space, 0)原创 2013-12-02 16:55:20 · 537 阅读 · 0 评论 -
oracle bulk collect for in
declare --定义表类型 type g_table is table of GPRS270_201311%rowtype index by pls_integer; --声明数组 g_datas g_table; begin --批量查询 select * bulk collect into g_datas from GPRS270_201311原创 2013-12-10 21:12:03 · 677 阅读 · 0 评论 -
oracle ping tns
liunx 执行命令:tnsping orcltest原创 2014-06-23 17:54:49 · 1584 阅读 · 0 评论