SELECT zdop.dsnet_plcy_id , zdop.strd_ym , zdop.dsnet_plcy_rgst_ownr_cl_cd , (SELECT zccd.comm_cd_val_nm FROM zngm_comm_cd_dtl zccd WHERE zccd.comm_cd_val = zdop.dsnet_plcy_rgst_ownr_cl_cd AND zccd.comm_cd_id = 'ZTPM_C_ORGCD' ) dsnet_plcy_rgst_ownr_cl_nm , zdop.dsnet_plcy_dtl_typ_cd , (SELECT zccd.comm_cd_val_nm FROM zngm_comm_cd_dtl zccd WHERE zccd.comm_cd_val = zdop.dsnet_plcy_dtl_typ_cd AND zccd.comm_cd_id = 'ZTPM_C_CHNLC' ) dsnet_plcy_dtl_typ_nm , zdop.brws_obj_cl_cd , zdop.sms_snd_yn , zdop.email_snd_yn , zdop.note_snd_yn , zdop.dsnet_plcy_prt_yn , Decode(zdop.open_yn, 'Y' , zdop.dsnet_plcy_title_nm, '[임시저장중]' ||
zdop.dsnet_plcy_title_nm) dsnet_plcy_title_nm , zdop.open_yn , zdop.atfil_rgst_id , zdop.rgst_org_id , (SELECT org_nm FROM zngm_org zo WHERE zo.org_id = zdop.rgst_org_id) rgst_org_nm , zdop.rgstr_id , SUBSTR(zdop.rgst_dtm, 0, 8) rgst_dt , (SELECT zu.han_nm FROM zngm_user zu WHERE zu.user_id = zdop.rgstr_id) rgstr_nm , zdop.audit_id , TO_CHAR(zdop.audit_dtm, 'yyyymmdd') audit_dt , (SELECT count(*) cnt FROM ztpm_dsnet_op_plcy_inq_answ zdopia WHERE zdopia.dsnet_plcy_id = zdop.dsnet_plcy_id) qa_cnt FROM ztpm_dsnet_op_plcy zdop %s WHERE zdop.strd_ym = :strd_year || :strd_month AND zdop.rgst_dtm BETWEEN nvl(:rgst_sta_dt, '20000101') || '000000' AND nvl(:rgst_end_dt, '99990101')
%s
在js里写语句替换两个“%S”
var table = "TABLE tab";
var where = "AND" + "CODE_ID = cur_id";
其中CODE_ID代表字段,cur_id代表变量。
请指教这样写对不对?应该怎样写才对呢?
zdop.dsnet_plcy_title_nm) dsnet_plcy_title_nm , zdop.open_yn , zdop.atfil_rgst_id , zdop.rgst_org_id , (SELECT org_nm FROM zngm_org zo WHERE zo.org_id = zdop.rgst_org_id) rgst_org_nm , zdop.rgstr_id , SUBSTR(zdop.rgst_dtm, 0, 8) rgst_dt , (SELECT zu.han_nm FROM zngm_user zu WHERE zu.user_id = zdop.rgstr_id) rgstr_nm , zdop.audit_id , TO_CHAR(zdop.audit_dtm, 'yyyymmdd') audit_dt , (SELECT count(*) cnt FROM ztpm_dsnet_op_plcy_inq_answ zdopia WHERE zdopia.dsnet_plcy_id = zdop.dsnet_plcy_id) qa_cnt FROM ztpm_dsnet_op_plcy zdop %s WHERE zdop.strd_ym = :strd_year || :strd_month AND zdop.rgst_dtm BETWEEN nvl(:rgst_sta_dt, '20000101') || '000000' AND nvl(:rgst_end_dt, '99990101')
%s
在js里写语句替换两个“%S”
var table = "TABLE tab";
var where = "AND" + "CODE_ID = cur_id";
其中CODE_ID代表字段,cur_id代表变量。
请指教这样写对不对?应该怎样写才对呢?
http://wangyi878750.blog.sohu.com/31370032.html