oracle查询所有所有的表结构及字段描述等信息并plsql保存查询结果
来源:互联网 发布:淘宝佣金软件购买 编辑:程序博客网 时间:2024/04/19 09:06
SELECT B.TABLE_NAME AS "表名",
C.COMMENTS AS "表说明",
B.COLUMN_ID AS "字段序号",
B.COLUMN_NAME AS "字段名",
B.DATA_TYPE AS "字段数据类型",
B.DATA_LENGTH AS "数据长度",
B.DATA_PRECISION AS "整数位",
B.DATA_SCALE AS "小数位",
A.COMMENTS AS "字段说明"
FROM ALL_COL_COMMENTS A, ALL_TAB_COLUMNS B, ALL_TAB_COMMENTS C
WHERE A.TABLE_NAME IN (SELECT U.TABLE_NAME FROM USER_ALL_TABLES U)
AND A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
AND C.TABLE_NAME = A.TABLE_NAME
AND C.OWNER = A.OWNER
group by B.COLUMN_NAME,C.COMMENTS, B.TABLE_NAME,A.COMMENTS
C.COMMENTS AS "表说明",
B.COLUMN_ID AS "字段序号",
B.COLUMN_NAME AS "字段名",
B.DATA_TYPE AS "字段数据类型",
B.DATA_LENGTH AS "数据长度",
B.DATA_PRECISION AS "整数位",
B.DATA_SCALE AS "小数位",
A.COMMENTS AS "字段说明"
FROM ALL_COL_COMMENTS A, ALL_TAB_COLUMNS B, ALL_TAB_COMMENTS C
WHERE A.TABLE_NAME IN (SELECT U.TABLE_NAME FROM USER_ALL_TABLES U)
AND A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
AND C.TABLE_NAME = A.TABLE_NAME
AND C.OWNER = A.OWNER
group by B.COLUMN_NAME,C.COMMENTS, B.TABLE_NAME,A.COMMENTS
ORDER BY B.TABLE_NAME,A.COMMENTS
其中group by 去除重复
plsql将查询结果,选中右键--->save results--->所有文件,xxx.txt
其中查询的列自定义
0 0
- oracle查询所有所有的表结构及字段描述等信息并plsql保存查询结果
- Oracle数据库查询表结构、字段及注释信息
- oracle查询表 索引、唯一约束、字段等相关信息
- 查询设置oracle的表注释字段注释等信息
- Oracle 查询表信息(字段+备注)
- Oracle 查询表信息(字段+备注)
- Oracle 查询表信息(字段+备注)
- SQL语句查询表结构信息(字段信息)
- PLsql 修改查询结果
- Java 实现SparkSQL保存查询结果带有字段信息到(header)HDFS
- hibernate hql 查询指定字段并获取结果集,多表查询结果集
- 查询Oracle表结构和注释信息
- Oracle查询表、视图、序列等信息查询
- Oracle查询所有 表、视图、序列等信息查询
- 数据库查询语句,oracle查询一个表中字段相同信息的个数并按个数排序
- oracle 查询表的结构和字段类型,字段长度
- Oracle语句及查询结果
- oracle 查询表结构并导出EXCEL
- flex 彩虹柱子
- 部署asp.net网站时出现“未在本地计算机上注册 Microsoft.Jet.OLEDB.4.0 提供程序”
- Android Bluetooth蓝牙开发\蓝牙协议\蓝牙通信例子_Android支持蓝牙4.0版本_BLE开发
- 解决MySql Error Code: 2006 – MySQL服务器已离线错误
- HDU 2399 GPA(简单字符串的处理)
- oracle查询所有所有的表结构及字段描述等信息并plsql保存查询结果
- Leetcode Sort List
- Apache Commons Pool试用小记
- GCD(Grand Central Dispatch)教程
- XTPToolKitPro
- jquery确认框和消息提示
- 如何做一个应用程序的快捷方式入口
- application Assembly里少J2EE modules
- Equals 方法和 HashCode方法