Sqlplus,设置 不换行,列宽,隐藏标题
来源:互联网 发布:周小平扒皮网络大v 编辑:程序博客网 时间:2024/06/11 13:03
set heading off,隐藏列标题set line 1000,设置行长度col XXX format a40(XXX为列名称,根据实际情况调整a40这个值),设置列宽
SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 13 10:03:55 2017Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> SELECT SEGMENT_NAME AS TABLE_NAME, 2 SUM(BYTES) / (1024 * 1024 * 1024) "TABLE_SIZE[GB]" 3 FROM DBA_SEGMENTS T 4 WHERE T.SEGMENT_NAME = 'BUSTB_TESTRESULT' 5 AND SEGMENT_TYPE = 'TABLE SUBPARTITION' 6 AND PARTITION_NAME LIKE 'RESULT_PART_201301%' 7 GROUP BY SEGMENT_NAME;TABLE_NAME--------------------------------------------------------------------------------TABLE_SIZE[GB]--------------BUSTB_TESTRESULT 8.19140625SQL> set wrap off;SQL> SELECT SEGMENT_NAME AS TABLE_NAME, 2 SUM(BYTES) / (1024 * 1024 * 1024) "TABLE_SIZE[GB]" 3 FROM DBA_SEGMENTS T 4 WHERE T.SEGMENT_NAME = 'BUSTB_TESTRESULT' 5 AND SEGMENT_TYPE = 'TABLE SUBPARTITION' 6 AND PARTITION_NAME LIKE 'RESULT_PART_201301%' 7 GROUP BY SEGMENT_NAME;rows will be truncatedTABLE_NAME--------------------------------------------------------------------------------BUSTB_TESTRESULTSQL> set line 4000;SQL> SELECT SEGMENT_NAME AS TABLE_NAME, 2 SUM(BYTES) / (1024 * 1024 * 1024) "TABLE_SIZE[GB]" 3 FROM DBA_SEGMENTS T 4 WHERE T.SEGMENT_NAME = 'BUSTB_TESTRESULT' 5 AND SEGMENT_TYPE = 'TABLE SUBPARTITION' 6 AND PARTITION_NAME LIKE 'RESULT_PART_201301%' 7 GROUP BY SEGMENT_NAME;TABLE_NAME TABLE_SIZE[GB]--------------------------------------------------------------------------------- --------------BUSTB_TESTRESULT 8.19140625SQL> set line 1000;SQL> SELECT SEGMENT_NAME AS TABLE_NAME, 2 SUM(BYTES) / (1024 * 1024 * 1024) "TABLE_SIZE[GB]" 3 FROM DBA_SEGMENTS T 4 WHERE T.SEGMENT_NAME = 'BUSTB_TESTRESULT' 5 AND SEGMENT_TYPE = 'TABLE SUBPARTITION' 6 AND PARTITION_NAME LIKE 'RESULT_PART_201301%' 7 GROUP BY SEGMENT_NAME;TABLE_NAME TABLE_SIZE[GB]--------------------------------------------------------------------------------- --------------BUSTB_TESTRESULT 8.19140625SQL> col TABLE_NMAE format a40;SQL> SELECT SEGMENT_NAME AS TABLE_NAME, 2 SUM(BYTES) / (1024 * 1024 * 1024) "TABLE_SIZE[GB]" 3 FROM DBA_SEGMENTS T 4 WHERE T.SEGMENT_NAME = 'BUSTB_TESTRESULT' 5 AND SEGMENT_TYPE = 'TABLE SUBPARTITION' 6 AND PARTITION_NAME LIKE 'RESULT_PART_201301%' 7 GROUP BY SEGMENT_NAME 8 ; TABLE_NAME TABLE_SIZE[GB]--------------------------------------------------------------------------------- --------------BUSTB_TESTRESULT 8.19140625SQL> col TABLE_NAME format a10;SQL> SELECT SEGMENT_NAME AS TABLE_NAME, 2 SUM(BYTES) / (1024 * 1024 * 1024) "TABLE_SIZE[GB]" 3 FROM DBA_SEGMENTS T 4 WHERE T.SEGMENT_NAME = 'BUSTB_TESTRESULT' 5 AND SEGMENT_TYPE = 'TABLE SUBPARTITION' 6 AND PARTITION_NAME LIKE 'RESULT_PART_201301%' 7 GROUP BY SEGMENT_NAME;TABLE_NAME TABLE_SIZE[GB]---------- --------------BUSTB_TEST 8.19140625SQL> set heading off;SQL> set heading offSQL> set line 4000SQL> SELECT SEGMENT_NAME AS TABLE_NAME, 2 SUM(BYTES) / (1024 * 1024 * 1024) "TABLE_SIZE[GB]" 3 FROM DBA_SEGMENTS T 4 WHERE T.SEGMENT_NAME = 'BUSTB_TESTRESULT' 5 AND SEGMENT_TYPE = 'TABLE SUBPARTITION' 6 AND PARTITION_NAME LIKE 'RESULT_PART_201301%' 7 GROUP BY SEGMENT_NAME 8 /BUSTB_TEST 8.19140625SQL> col TABLE_NAME format a20;SQL> SELECT SEGMENT_NAME AS TABLE_NAME, 2 SUM(BYTES) / (1024 * 1024 * 1024) "TABLE_SIZE[GB]" 3 FROM DBA_SEGMENTS T 4 WHERE T.SEGMENT_NAME = 'BUSTB_TESTRESULT' 5 AND SEGMENT_TYPE = 'TABLE SUBPARTITION' 6 AND PARTITION_NAME LIKE 'RESULT_PART_201301%' 7 GROUP BY SEGMENT_NAME;BUSTB_TESTRESULT 8.19140625SQL> set heading on;SQL> SELECT SEGMENT_NAME AS TABLE_NAME, 2 SUM(BYTES) / (1024 * 1024 * 1024) "TABLE_SIZE[GB]" 3 FROM DBA_SEGMENTS T 4 WHERE T.SEGMENT_NAME = 'BUSTB_TESTRESULT' 5 AND SEGMENT_TYPE = 'TABLE SUBPARTITION' 6 AND PARTITION_NAME LIKE 'RESULT_PART_201301%' 7 GROUP BY SEGMENT_NAME;TABLE_NAME TABLE_SIZE[GB]-------------------- --------------BUSTB_TESTRESULT 8.19140625SQL>
阅读全文
0 0
- Sqlplus,设置 不换行,列宽,隐藏标题
- DataGridView设置列标题不换行
- DataGridView设置列标题不换行
- C#中如何设置DataGridView列标题不换行
- sqlplus无法显示列标题
- 设置单元格不换行,多出的部分隐藏
- SQLPLUS中设置输出数据库的列宽
- DataGridView设置列标题
- C# DataGrid设置列标题列宽代码
- COGNOS设置隐藏列
- 设置单元格不换行
- 设置td不换行
- subLime设置不换行
- sqlplus 列设置与报表应用
- C# WinForm中DataGrid列设置(列宽/列标题等)
- C# WinForm中DataGrid列设置(列宽/列标题等)
- C# WinCE中DataGrid列设置(列宽 列标题等)
- 设置Repeater隐藏某列
- Ajax跨域请求COOKIE无法带上的解决办法
- python 错误总结
- C语言中常用计时方法总结
- Leetcode算法学习日志-48 Rotate Image
- 数据结构第十周项目——验证算法(三)
- Sqlplus,设置 不换行,列宽,隐藏标题
- iOS
- 曼彻斯特编码
- vue之watch用法
- 实现ajax的队列请求
- 第12周【项目
- DOM的innerHTML
- 第21章 OpenWrt串口的使用1
- GAN的基本原理、应用和走向