-
Ora-24347
os windows2000/9i
I ran the query via SQL*Plus and got the following error:
ORA-24347: Warning of a NULL column in an aggregate function
no rows selecte;
SELECT vw_explo.fyi_lab_report, vw_explo.fyi_reference_id,
vw_explo.sys_author, vw_explo.fyi_un_number, vw_explo.fyi_un_ship_name,
vw_explo.fyi_un_haz_class, vw_explo.sys_keywords,
vw_explo.fyi_ship_name, vw_explo.sys_title
FROM vw_explo vw_explo
WHERE ( (UPPER (vw_explo.fyi_lab_report) = UPPER ('173.56(j)')
)
OR (( NOT (SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 15) = UPPER ('u.s. department')
OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 6) = UPPER ('israel')
OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 5) = UPPER ('pains')
OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 8) = UPPER ('ministry')
OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 6) = UPPER ('morton')
OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 7) = UPPER ('thiokol')
OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 4) = UPPER ('taas')
OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 18) = UPPER ('atlantic research')
OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 8) = UPPER ('mcdonnel')
OR SUBSTR(UPPER (vw_explo.fyi_reference_id), 1, 16) = UPPER ('martin marietta')
)
)
AND ( (vw_explo.fyi_un_number = 'UN0093'
OR vw_explo.fyi_un_number = 'UN0333'
OR vw_explo.fyi_un_number = 'UN0334'
OR vw_explo.fyi_un_number = 'UN0335'
OR vw_explo.fyi_un_number = 'UN0336'
OR vw_explo.fyi_un_number = 'UN0337'
OR vw_explo.fyi_un_number = 'UN0349'
OR vw_explo.fyi_un_number = 'UN0351'
OR vw_explo.fyi_un_number = 'UN0430'
OR vw_explo.fyi_un_number = 'UN0432'
OR vw_explo.fyi_un_number = 'UN0477'
OR vw_explo.fyi_un_number = 'UN1325'
OR vw_explo.fyi_un_number = 'NA0323'
OR vw_explo.fyi_un_number = 'NA0337'
OR SUBSTR(UPPER(vw_explo.sys_title), 1, 7) = UPPER ('firework')
OR SUBSTR(UPPER(vw_explo.sys_title) , 1, 5) = UPPER ('trick')
OR SUBSTR(UPPER(vw_explo.sys_title) , 1, 3) = UPPER ('toy')
)
)
)
);
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|