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!

ISDATE function oracle

sgudipudiOct 5 2016 — edited Oct 8 2016

Hi,

I have seen the documetation about ISDATE funtion but i can't call this function in oracle.

My DB version

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

"CORE 11.2.0.4.0 Production"

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

select isdate('20161005') from dual;

ORA-00904: "ISDATE": invalid identifier

00904. 00000 - "%s: invalid identifier"

*Cause:

*Action:

Error at Line: 59 Column: 8

https://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_functions_1106.htm

Can someone throw light on this?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2016

Added on Oct 5 2016

22 comments

10,425 views