When trying to write a simple query that takes the minutes from a date/time column functions aren't recognized, DATEPART, DATEDIFF, and DATEADD. Why is Toad not accepting these?
What Oracle commands are supported by Toad?
DATEPART, DATEDIFF, and DATEADD are not Oracle functions. These are SQL Server functions and cannot be used in Toad.
Toad will support Oracle PL/SQL commands. If it can run in SQL Plus then it can most likely run in Toad.
There are a few SQL*Plus commands that Toad does not support. Please refer to the Knowledge Base Article 35317 or check the Toad Help file for a list of these commands that are supported, unsupported, and ignored.
