Restituisci
-
Titolo
Error formatting a nested SELECT statement in a WHERE clause: "ORA-00905: missing keyword" -
Descrizione
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 -
Causa
A query with a nested SELECT in a WHERE clause will add an errand extra set of parenthesis in the FROM clause.
-
Risoluzione
WORKAROUND:
Remove the first set parenthesis () in the FROM clause.
STATUS:
Waiting for fix in a future version of SQL Navigator for Oracle. -
ID difetto
ST5749