PL/SQL Beautifier Enhacement request.

[RaghuB]

Hi,

It would be better if we have a linefeeds option in the PL/SQL beautifier options. It would be nice if we have the following options.

Atlease one Newline

1. Around DML Statement.
2. Around a Type Statement.
3. Around a Program Unit Declaration
4. Around a Cursor declaration.
5. Around a Program Unit body.
6. Around a CASE statement
7. Around a PL/SQL block.
8. Before a Label.
9. Around Anynonmous blocks,Views,triggers and object types.
10. Around all other commands.

The other enhacements would be

1. The code contents window made as dockable.The code contents windows
could be moved to either right or left of the prrgram window.

2. Status bar can be turned on or off depending on option.

3. The color palette in the PL/SQL Developer should be enhanced
more to include more colors. User should be able to enter the
RGB values both for fonts and syntax highlighting section.

Regards
Raghu

 

[Marco Kalter]

What exactly would this option do? Can you provide an example?

 

[RaghuB]

Hi Marco,

Thanks for the reply.
The examples is shown below.

IF l_reference_balance_record.mtm_inc > 0 THEN
debug.pr_debug('Testing');
l_reference_balance_record.total_reval_loss := 0;
END IF;
x := x + 1;
...

CREATE OR REPLACE PROCEDURE pr_test AS
l_rec VARCHAR(1);
BEGIN
....
END;

The PL/SQL Beautifier would beautify it to

IF l_reference_balance_record.mtm_inc > 0 THEN
debug.pr_debug('Testing');
l_reference_balance_record.total_reval_loss := 0;
END IF;
--New line inserted here
x := x+1;
...

 

[Marco Kalter]

You mean an extra empty line? I have added this to the list of enhancement requests?