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:
另外,","放前面总觉得怪怪的,建议改成这样吧:
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;