Export the table decribe from oracle data dictionary

原创 2011年01月19日 10:40:00

select b.TABLE_NAME as tablename,
       --c.comments as "表说明",  
       --b.COLUMN_ID as "字段序号",  
       b.COLUMN_NAME as Name,
       b.DATA_TYPE || '(' || decode(b.DATA_TYPE,
                                    'NUMBER',
                                    b.DATA_PRECISION || ',' || b.DATA_SCALE,
                                    b.DATA_LENGTH) || ')' as type,
       b.NULLABLE,
       b.DATA_DEFAULT ,
       a.comments
  from all_col_comments a, all_tab_columns b, all_tab_comments c
 where 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
   and a.TABLE_NAME in ('T_ACTION','T_ANSWER')
 order by a.table_name, b.column_id;

 

版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

Export large data from GridView to Excel file using C#

A good way to display data is to show it in a GridView. However, it becomes difficult to manipulate ...

import export data from DataTable

CSV 1. return a string public string ToStringAsCSV (DataTable dt, string delimited) { ...

How to export/import data with LOB type from one user/schema to another

How to export/import data with LOB type from one user/schema to another? [ID 464558.1] ...

Export data to Excel from Silverlight/WPF DataGrid

Data export from DataGrid to Excel is very common task, and it can be solved with different ways, an...

Generate Data Dictionary from SQL Server

目录 目录 Introduction Using the code License 原文链接:http://www.codeproject.com/Tips/501909/Generate-Data-...

Export table data sql scrpit on sql server 2008

Since this is my first time working on sql server, I didn't know how to export data. Previously, I w...

Data dictionary for oracle 2.0

  • 2012-11-29 23:31
  • 5.30MB
  • 下载

103.Which two statements are true regarding the Oracle Data Pump export and import operations? (Choo

103.Which two statements are true regarding the Oracle Data Pump export and import operations? (Choo...

Dump data from PostgreSQL's table which have few bad blocks

PostgreSQL bad blocks
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)