Oracle拼接序列

                 //添加

                StringBuilder strAdd = new StringBuilder();
                strAdd.Append("INSERT INTO JN_BASE_STATION(STATION_ID,CITY,COUNTY,STATION_NAME,LONGITUDE,LATITUDE,");
                strAdd.Append("PROPERTY_1,PROPERTY_2,STATION_TYPE,SOLVE_PROBLEM,STATION_DEPLOY,MAIN_MATE,POWER_AIR,");
                strAdd.Append("ELECTRICITY,TOWER_ROOM,OTHER_FEE,TOTAL_FEE,ADD_USERID,ADD_USERNAME,ADD_TIME) VALUES(");

                 //主键：生成的序列加上当前用户工号(拼接序列)
                strAdd.Append("SEQ_SYSTEM.nextval || '" + Session["USERID"].ToString() + "',");

转载于:https://www.cnblogs.com/qq1040991197/archive/2012/10/11/2720060.html