Cannot format or optimize SQL statements using IGNORE NULLS clause. (4223495)

Toad 9.01 and below cannot format or tune IGNORE NULLS statement which is part of the Analytic function FIRST_VALUE and LAST_VALUE.

Steps to replicate:
Apply the FIRST_VALUE statement with IGNORE NULLS on any sample table you might have.
Example:
SELECT First_value (
(
SYSDATE
) IGNORE NULLS
) OVER () AS t1
FROM dual;

Optimizer also states "This type of SQL statement is not supported error" when attempting to optimize a statement using this clause.

Toad relies on third party code for both Formatting and SQL Tuning and both components do not support the newest syntax for IGNORE NULLS yet.

WORKAROUND:
Remove IGNORE NULL clause in order to optimize the query and then add it back to the alternate statements.

STATUS:
Enhancement request CR0205965 has been submitted to Development for consideration in a future release of Toad for Oracle and Quest SQL Optimizer for Oracle.