Changing the SQL that runs when focused on the result grid as follows will solve the problem.
Select Col.*,
(Select Max(Com.Comments)
From Sys.All_Col_Comments Com
Where Com.Owner = Col.Owner
And Com.Table_Name = Col.Table_Name
And...
I tried SQL for all possible OPTIMIZER_FEATURES_ENABLE values according to Oracle's 19c documentation.
Doesn't work for 8.0.0 through 10.2.0.4 .
Works for 10.2.0.5 to 19.1.0
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/OPTIMIZER_FEATURES_ENABLE.html...
Our license is for "PL/SQL Developer 14". We are experiencing the problem in "PL/SQL Developer 14".
The same problem occurs when we try it with "PL/SQL Developer 15".
I am sending the "debug.txt" file and screenshot for both versions.
The problem occurs when the optimizer is changed with the...
When OPTIMIZER_FEATURES_ENABLE value is set to 8.1.7 in Oracle 19c database, ORA-1719 error occurs when clicking anywhere in the result window of SQL Window. Is there any way to solve this problem?