-- mysql
desc tablename
--oracle table_name 的值必须是大写
select COLUMN_NAME,DATA_TYPE,DATA_LENGTH ,t.* from user_tab_columns t where table_name='DB_GOODS_CODE';
-- mysql
desc tablename
--oracle table_name 的值必须是大写
select COLUMN_NAME,DATA_TYPE,DATA_LENGTH ,t.* from user_tab_columns t where table_name='DB_GOODS_CODE';