oracle 生成OracleDataReader代码

select ‘huizhuo.‘||a.column_name||‘=‘||
case
when a.data_type=‘VARCHAR2‘ then ‘dr["‘||a.column_name||‘"]!=DBNull.Value?dr["‘||a.column_name||‘"].ToString():"";‘
when a.data_type=‘NUMBER‘ and a.nullable=‘N‘ then ‘Convert.ToDecimal(dr["‘||a.column_name||‘"]);‘
when a.data_type=‘NUMBER‘ and a.nullable=‘Y‘ then ‘dr["‘||a.column_name||‘"]!=DBNull.Value?Convert.ToDecimal(dr["‘||a.column_name||‘"]):0;‘
else ‘dr["‘||a.column_name||‘"].ToString();‘ end
from USER_TAB_COLUMNS a
where table_name=‘视图名‘

oracle 生成OracleDataReader代码

原文：https://www.cnblogs.com/cjdbk/p/11382228.html