Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ANSI SQL

401820Sep 19 2007 — edited Sep 25 2007

I wanted to test some SQL to make sure it was SQL 92 compliant. My understanding is that the command I was using was compilant.

I set on the validator:

ALTER SESSION SET flagger=FULL;

and issued the statement:

SELECT
COALESCE(
NULL, 34, 13, 0
)
from
dual;

But I get the error:

ERROR at line 4:
ORA-00097: use of Oracle SQL feature not in SQL92 Full Level
ORA-06550: line 4, column 1:
PLS-01413: Use of NULL an expression
ORA-06550: line 3, column 1:
PLS-01416: Use of <id> (<value>...) here

So I tried this:

SELECT
COALESCE(
'', 34, 13, 0
)
from
dual;

But get:

ERROR at line 4:
ORA-00097: use of Oracle SQL feature not in SQL92 Full Level
ORA-06550: line 4, column 3:
PLS-01466: Null strings are not allowed
ORA-06550: line 3, column 1:
PLS-01416: Use of <id> (<value>...) here

Any ideas what I am doing wrong, please?

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2007
Added on Sep 19 2007
16 comments
728 views