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) { ...
  • zexu82
  • zexu82
  • 2011年08月16日 23:50
  • 598

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...
  • hgjsoft
  • hgjsoft
  • 2011年09月27日 22:26
  • 988

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.3MB
  • 下载

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

PostgreSQL bad blocks

Moving Data from HDFS to Hive Using an External Table

原文链接:http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_dataintegration/content/moving_data_...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Export the table decribe from oracle data dictionary
举报原因:
原因补充:

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