查看表的属性:
COLUMN_NAME:字段名
DATA_TYPE:数据类型
DATA_LENGTH:字段长度
TABLENAME:表名!!!一定要大写!!!
select A.COLUMN_NAME,A.DATA_TYPE,A.DATA_LENGTH from user_tab_columns A where TABLE_NAME = 'TABLENAME'
查看表的属性:
COLUMN_NAME:字段名
DATA_TYPE:数据类型
DATA_LENGTH:字段长度
TABLENAME:表名!!!一定要大写!!!
select A.COLUMN_NAME,A.DATA_TYPE,A.DATA_LENGTH from user_tab_columns A where TABLE_NAME = 'TABLENAME'