Error formatting a nested SELECT statement in a WHERE clause: "ORA-00905: missing keyword" (4274926)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error formatting a nested SELECT statement in a WHERE clause: "ORA-00905: missing keyword"
Description

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
Cause

A query with a nested SELECT in a WHERE clause will add an errand extra set of parenthesis in the FROM clause.
Resolution

WORKAROUND:
Remove the first set parenthesis () in the FROM clause.

STATUS:
Waiting for fix in a future version of SQL Navigator for Oracle.
Defect ID

ST5749

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title