查询Oracle的数据字典表
sSQL:= 'SELECT OWNER,TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_TYPE_MOD'
+ ',DATA_TYPE_OWNER,DATA_LENGTH,DATA_PRECISION,DATA_SCALE,NULLABLE'
+ ',COLUMN_ID,DEFAULT_LENGTH,DATA_DEFAULT,NUM_DISTINCT,LOW_VALUE'
+ ',HIGH_VALUE,DENSITY,NUM_NULLS,NUM_BUCKETS,LAST_ANALYZED'
+ ',SAMPLE_SIZE,CHARACTER_SET_NAME,CHAR_COL_DECL_LENGTH,GLOBAL_STATS'
+ ',USER_STATS,AVG_COL_LEN'
+ ' FROM ALL_TAB_COLUMNS'
+ ' WHERE OWNER=''' + UpperCase(Trim(cbUsers.Text)) + ''''
+ ' AND TABLE_NAME=''' + UpperCase(lvViews.Selected.Caption) + ''''
+ ' ORDER BY COLUMN_ID';
sSQL:= 'SELECT OWNER,TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_TYPE_MOD'
+ ',DATA_TYPE_OWNER,DATA_LENGTH,DATA_PRECISION,DATA_SCALE,NULLABLE'
+ ',COLUMN_ID,DEFAULT_LENGTH,DATA_DEFAULT,NUM_DISTINCT,LOW_VALUE'
+ ',HIGH_VALUE,DENSITY,NUM_NULLS,NUM_BUCKETS,LAST_ANALYZED'
+ ',SAMPLE_SIZE,CHARACTER_SET_NAME,CHAR_COL_DECL_LENGTH,GLOBAL_STATS'
+ ',USER_STATS,AVG_COL_LEN'
+ ' FROM ALL_TAB_COLUMNS'
+ ' WHERE OWNER=''' + UpperCase(Trim(cbUsers.Text)) + ''''
+ ' AND TABLE_NAME=''' + UpperCase(lvViews.Selected.Caption) + ''''
+ ' ORDER BY COLUMN_ID';
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货