select
A.column_name ,A.data_type ,A.data_length ,A.data_precision ,
A.Data_Scale ,A.nullable ,A.Data_default ,B.comments
from
user_tab_columns A,user_col_comments B
where
A.Table_Name = B.Table_Name
and A.Column_Name = B.Column_Name
and A.Table_Name = 'updcostvalue'查出来的表体都是空的。
有类似SQL的SP_HELP的语句吗?
A.column_name ,A.data_type ,A.data_length ,A.data_precision ,
A.Data_Scale ,A.nullable ,A.Data_default ,B.comments
from
user_tab_columns A,user_col_comments B
where
A.Table_Name = B.Table_Name
and A.Column_Name = B.Column_Name
and A.Table_Name = 'updcostvalue'查出来的表体都是空的。
有类似SQL的SP_HELP的语句吗?
http://blog.csdn.net/qyweiyy88/article/details/6627610
select
A.column_name ,A.data_type ,A.data_length ,A.data_precision ,
A.Data_Scale ,A.nullable ,A.Data_default ,B.comments
from
user_tab_columns A,user_col_comments B
where
A.Table_Name = B.Table_Name
and A.Column_Name = B.Column_Name
and A.Table_Name = upper('updcostvalue')
;