Home
IDEs Support (IntelliJ Platform) | JetBrains
Contact Support
Community
Sign in
Kra
Total activity
7
Last activity
December 02, 2022 15:53
Member since
November 09, 2022 08:05
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2
Activity overview
Posts (2)
Comments (3)
Sort by recent activity
Recent activity
Votes
Edited
December 02, 2022 15:53
FYI, we have found out that EXPLAIN PLAN works properly using "?" in IntelliJ 2021.2 Build #IU-212.4746.92, but this is as far as we can see the last version where it works. It does not work in Int...
Community
IntelliJ IDEA Users
Cannot use "?" in Explain Plan
0 votes
Created
December 02, 2022 14:13
Sadly, using ":1" instead of "?" does not work properly. It seems that when using ":1" the order of the values in the WHERE clause is not preserved, thus leading to wrong cost in explain plan. Usin...
Community
IntelliJ IDEA Users
Cannot use "?" in Explain Plan
0 votes
Created
November 09, 2022 10:42
HR> EXPLAIN PLAN SET STATEMENT_ID = 'oj0tgh/14pN9ZXg4J/hA6Q==' INTO "PLAN_TABLE" FOR select * from DUAL where dummy = ?[2022-11-09 11:42:20] [22019][911] ORA-00911: invalid character[2022-11-09 11:...
Community
IntelliJ IDEA Users
Cannot use "?" in Explain Plan
0 votes