123

Sql code posted
created at 09 Jul 10:54, updated at 23 Jul 12:30

Edit | Back 
1
2
3
4
5
6
 
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.COLUMN_NAME=b.column_name and A.Table_Name = B.Table_Name and 
A.Table_Name='ICCY_V_TOKEN'
346 Bytes in 2 ms with coderay