auto select

[dnador]

I like a lot of the features on the new version, but I have this one issue.

I'm not sure that this is explicitly expressed in other topics, but autoselect is ruined in v7.
even with auto select checked in the settings it selects the whole file if I have a pl/sql block in it. I have to highlight the query to run it or comment our the pl/sql block then it works. its a pain.

also is there a way to tone down the highlight color on the autoselect? It is hard to read after its run and there is no way to deselect it unless you run another query:-(.

 

[ScottMattes]

Marco van der Linden gave me this answer:

It's the hot track highlighting of the program window preferences

 

[dnador]

Thanks Scott,
I found that. Now if only the autoselect would work like it used to:-(

 

[Marco Kalter]

PL/SQL Blocks need to be terminated with a slash. For example

select * from emp;
begin
  null;
end;
/
select * from dept;

This way the AutoSelect function should be able to pick up all individual statements and PL/SQL Blocks.

 

[dnador]

Thanks Marco...I tried that and it works great!
Dave