This content has been marked as final.
Show 5 replies
-
1. Re: 30EA2 - Bugs?
nudo Jan 18, 2011 4:45 PM (in response to nudo)Also happens in previous versions. -
2. Re: 30EA2 - Bugs?
Vadim Tropashko-Oracle Jan 18, 2011 9:54 PM (in response to nudo)Would collapsing a 3-line block or query achieve anything other than cluttering code editor gutter? If most users agree with you, we can certainly change that. Can the others express their opinion here, or you can submit a feature request for voting on OTN.
I agree that collapsed PL/SQL blocks expanding when edited outside them this is a bug (11658397). -
3. Re: 30EA2 - Bugs?
-K- Jan 19, 2011 10:51 AM (in response to Vadim Tropashko-Oracle)I'd say no, no more clutter. I only collapse to get to a piece of code without scrolling, and a few lines don't stand in the way for that.
Thanks,
K. -
4. Re: 30EA2 - Bugs?
nudo Feb 28, 2011 6:55 PM (in response to -K-)I am more concerned with the keyboard shortcut not working and the auto expanding when editing outside of a block (which looks like it may be fixed in EA4, thank you).
I see that the editor seems to start collapsing after reaching 4 lines of code, I didn't recognize the pattern at first.
I do not often need to collapse 3 lines of code, however when editing scripts with thousands of lines of smaller code blocks , it becomes tedious. Often I need to focus on a small set of code blocks in a large script and with thousands of lines between, it becomes difficult moving between them. I can use bookmarks for this, but I prefer to drill into my code.
Triggers for instance do not collapse to a single line in the code editor. The highest level that is collapsible is the begin -> end blocks. So if I have a 100 triggers in a script and I collapse all statements, instead of 100 lines (plus whitespace) I get hundreds.
i.e.
Instead of:
CREATE OR REPLACE TRIGGER "TRIGGER_NAME"...
CREATE OR REPLACE TRIGGER "TRIGGER_NAME"...
I see:
CREATE OR REPLACE TRIGGER "TRIGGER_NAME"
BEFORE INSERT
ON "TABLE_NAME"
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
VARIABLE_NAME VARIABLE_TYPE;
VARIABLE_NAME VARIABLE_TYPE;
VARIABLE_NAME VARIABLE_TYPE;
VARIABLE_NAME VARIABLE_TYPE;
BEGIN...;
CREATE OR REPLACE TRIGGER "TRIGGER_NAME"
BEFORE INSERT
ON "TABLE_NAME"
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
VARIABLE_NAME VARIABLE_TYPE;
VARIABLE_NAME VARIABLE_TYPE;
VARIABLE_NAME VARIABLE_TYPE;
VARIABLE_NAME VARIABLE_TYPE;
BEGIN...;
Create table blocks collapse to:
CREATE TABLE "TABLE_NAME" ...
CREATE TABLE "TABLE_NAME" ...
Edited by: user3910740 on Feb 28, 2011 10:54 AM -
5. Re: 30EA2 - Bugs?
nudo Mar 10, 2011 9:03 PM (in response to nudo)I was wrong, 11658397 is not fixed in EA4