I've been using the Standard Edition 3.10.12 for few days and I must say that the code editor, completion and debugging is simply outstanding...that's why I bought it after all
.However nothing is absolutely perfect and I found these bugs (so far):
1) The code formatter does not properly format variables declared in the package specification (in my preferences I have Text Case=>Variable Case=>As in the declaration).
Steps to reproduce:
CREATE OR REPLACE package test_pkg
as
C_MY_CONSTANT constant number := 0;
end test_pkg;
/
CREATE OR REPLACE package body test_pkg
as
function return_my_constant
return number
is
begin
return C_MY_CONSTANT;
end return_my_constant;
end test_pkg;
Now format the package body and c_my_constant is lowercase, but is declared uppercase.
2) Code completion in with clause adds double quotes
Steps to reproduce:
with dd as (
select lower( dummy) lower_dummy from dual)
select dd.[ now hit ctrl+space and choose the first insight => Tab] from dd;
dd.lower_dummy should be inserted but dd."lower_dummy" is inserted instead, so the resulting query fails with the Error: ORA-00904: "DD"."lower_dummy": invalid identifier
3) This is not exactly a bug, just some inconsistency/misbehavior in the code editor.
I start typing
insert into dept ([now ctrl+space]
and here I would like to specify all the fields (or some subset). If I do the same for a select statement, e.g.
select [hit ctrl+space] from dept d;
I get the option to check the entire table at once and I would expect something similar for insert as well - it would definitely make my life way easier.
Best regards,
Pavel