oracle怎么查看表字段的类型
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) )
---- 动动手指关注我!或许下次你又能在我这里找到你需要的答案!ZZZZW与你一起学习,一起进步!