oracle怎么查看表字段的类型

时间：2015-12-23 02:02:49 收藏：0 阅读：758



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