Question

在数据库的一个表中如何查询共有多少字段

Answer 1

sql>desc table_name
或
select c.COLUMN_NAME,
c.DATA_TYPE,
c.DATA_PRECISION,
c.DATA_SCALE,
c.NULLABLE,
c.DATA_DEFAULT,
c.NUM_DISTINCT,
c.DENSITY,
c.NUM_NULLS,
c.NUM_BUCKETS,
c.HISTOGRAM
from dba_tab_columns c
where c.table_name in upper('表名')

Answer 2

select a.* from sys.columns a,sys.tables b
where a.object_id = b.object_id and b.name = '要查的表名'