"Define Timestamp" Shows Different Result From SQL Developer and SQLPLUS
(Doc ID 1664020.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle SQL Developer - Version 3.2 and later
SQL*Plus - Version 184.108.40.206 and later
Information in this document applies to any platform.
Scripts containing "Define timestamp" as
DEFINE <variableName> = timestamp '2014-04-01 00:00:00';
Which is required for a scheduled job, Is developed and tested fine on SQL Developer.
However when running same script from SQL*Plus, it throws exception
Error: ORA-00904: "TIMESTAMP": invalid identifier
Scripts working at SQL Developer now moved to SQL*Plus
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!