select column_name,data_type,DATA_LENGTH From all_tab_columns where table_name=upper(‘表名‘) AND owner=upper(‘数据库登录用户名‘) select column_name,data_type,DATA_LENGTH From all_tab_columns where table_name=upper(‘Mid_Payinfo‘) AND owner=upper(‘cgtest‘)
create table Mid_Payinfo( GUID VARCHAR2(100), DkAmount NUMBER(22), CreateBy Varchar(40), CreateDate Date, ApproveDate Date, ApprovedBy Varchar2(40), SFProviderCode varchar2(80), SFProviderName varchar2(200), PayDate Date, Billstate number（22）, BillPk varchar2(100) )
原文：http://www.cnblogs.com/zzzzw/p/5068672.html