I’m new to SQL Navigator 5.5 and find it quite difficult to get started with the product for Oracle 9i:
Just trying out a simple SQL in a stored procedure the column function substr(…) is recognised as such and appears in bold black type, but not for example dateadd(…):
PL/SQL: ORA-00904: '"DATEADD"invalid identifier.
Why? Dateadd works in SQLPlus. The Help tool is no use as it doesn’t even mention column functions or substr. Where do I get a list of the function set which is available in SQL Navigator ?
PS. A tutorial or some examples would be nice!