Formatting SQL generates "ORA-00905" error with nested SELECT in a WHERE clause.
Formatting problem only occurs in version 6.1 executing sql code.
Code is formatted properly in version 5.5
A query with a nested SELECT in a WHERE clause will add an errand extra set of parenthesis in the FROM clause.
WORKAROUND:
Remove the first set parenthesis () in the FROM clause.
STATUS:
Waiting for fix in a future version of SQL Navigator for Oracle.
