SELECT '/// <summary>'||chr(13)||'///'||t2.comments||chr(13)||'///</summary>'||chr(13)||'public '||DECODE(t1.data_type,'CHAR','string','VARCHAR2','string','DATE','DateTime','NUMBER','Double','string')||' '||t2.column_name||' { get; set; }'||chr(13) 属性 from user_tab_columns t1 join user_col_comments t2 on t1.table_name=t2.table_name and t1.column_name=t2.column_name where t1.table_name='NSHR_DIYIndexRule' order by t1.column_id;--实体
SELECT t1.COLUMN_NAME ||'=reader["'||t1.COLUMN_NAME||'"].ToString(),' FROM user_col_comments t1 WHERE t1.TABLE_NAME='NSHR_DIYIndexRule';--reader
SELECT 'SELECT '|| WMSYS.WM_CONCAT('t1.'||t1.COLUMN_NAME)||' from TEM.NSHR_DIYIndexName t1 ' FROM user_col_comments t1 WHERE t1.TABLE_NAME=UPPER('NSHR_DIYIndexRule');--select
SELECT 'INSERT INTO TEM.NSHR_SationSystem (' || WMSYS.WM_CONCAT(t1.COLUMN_NAME)||') VALUES ('|| WMSYS.WM_CONCAT(':'||t1.COLUMN_NAME)||')' FROM user_col_comments t1 WHERE t1.TABLE_NAME=UPPER('NSHR_SationSystem');--insert
SELECT 'UPDATE TEM.NSHR_SationSystem SET '|| WMSYS.WM_CONCAT(t1.COLUMN_NAME||'=:'||t1.COLUMN_NAME) FROM user_col_comments t1 WHERE t1.TABLE_NAME=UPPER('NSHR_SationSystem');--update
SELECT 'parameterList.Add(Common.OracleHelper.GetParameter(":'||t1.COLUMN_NAME||'",'||t1.DATA_LENGTH||',stationSystem.UN_ID));' FROM user_tab_columns t1 WHERE t1.TABLE_NAME=UPPER('NSHR_SationSystem');--parameter
Oracle助你加快项目开发的实用语句
最新推荐文章于 2024-09-26 15:19:34 发布