Oracle助你加快项目开发的实用语句

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