try it .. SQL> desc dual; Name Type Nullable Default Comments ----- ----------- -------- ------- -------- DUMMY VARCHAR2(1) Y SQL> select * from all_tab_columns a where a.TABLE_NAME = upper('DUAL');
select column_name, data_default from all_tab_columns where table_name='YOURTABLENAME'
select * from user_tab_columns where table_name='tablename'
SQL> desc dual;
Name Type Nullable Default Comments
----- ----------- -------- ------- --------
DUMMY VARCHAR2(1) Y SQL> select * from all_tab_columns a where a.TABLE_NAME = upper('DUAL');
from all_tab_columns
where table_name='YOURTABLENAME'
比如我查user_tables表中NEXT_EXTENT这一列的默认值,还是查不出来
PCT_USED
FREELISTS
FREELIST_GROUPS
NEXT_EXTENT
PCT_INCREASE
用之前各位教的方法,查询user_tab_columns,可是里面的值还是空的,不知道应该怎么个查法。