SELECT
ans.inq_answ_ctt
, ans.rgst_org_id
, (SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_org_nm
, ans.rgstr_id
, SUBSTR(ans.rgst_dtm, 0, 8)rgst_dt
FROM ztpm_dsnet_op_plcy_inq_answ ans
WHERE ans.dsnet_plcy_id =:dsnet_plcy_id
提示有语法错误,以下是提示:
,(SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_org_nm
..............1
PCC-S-02201, Encountered the symbol "org_nm" when expecting one of the following
:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
The symbol ")" was substituted for "org_nm" to continue.
Syntax error at line 102, column 72, file pdb_ztpm_dsnet_op_plcy_inq_answ_f0002_2_1.pc:
Error at line 102, column 72 in file pdb_ztpm_dsnet_op_plcy_inq_answ_f0002_2_1.p
c
, (SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_or
g_nm
.......................................................................1
PCC-S-02201, Encountered the symbol ")" when expecting one of the following:
ans.inq_answ_ctt
, ans.rgst_org_id
, (SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_org_nm
, ans.rgstr_id
, SUBSTR(ans.rgst_dtm, 0, 8)rgst_dt
FROM ztpm_dsnet_op_plcy_inq_answ ans
WHERE ans.dsnet_plcy_id =:dsnet_plcy_id
提示有语法错误,以下是提示:
,(SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_org_nm
..............1
PCC-S-02201, Encountered the symbol "org_nm" when expecting one of the following
:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
The symbol ")" was substituted for "org_nm" to continue.
Syntax error at line 102, column 72, file pdb_ztpm_dsnet_op_plcy_inq_answ_f0002_2_1.pc:
Error at line 102, column 72 in file pdb_ztpm_dsnet_op_plcy_inq_answ_f0002_2_1.p
c
, (SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_or
g_nm
.......................................................................1
PCC-S-02201, Encountered the symbol ")" when expecting one of the following:
ans.inq_answ_ctt
, ans.rgst_org_id
, rgst_org_nm.org_nm
, ans.rgstr_id
, SUBSTR(ans.rgst_dtm, 0, 8)rgst_dt
FROM ztpm_dsnet_op_plcy_inq_answ ans ,
(SELECT org_nm FROM zngm_org zo ) rgst_org_nm
WHERE ans.dsnet_plcy_id =:dsnet_plcy_id
and rgst_org_nm.org_id = ans.rgst_org_id---估计这个select 是这个意思;
另外这个 :dsnet_plcy_id 动态参数也最好换成相应的值
试下