Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Formatting PL/SQL in SQLDev 20.2.0 - Unwanted Indentation after Comment - Solution?

Philipp SalvisbergJun 28 2020 — edited Jul 2 2020

When I format the following Code in SQL Developer 20.2

BEGIN

-- a comment

NULL;

END;

/

I get this the first time:

BEGIN

-- a comment

   NULL;

END;

/

and this after formatting it the second time:

BEGIN

-- a comment

      NULL;

END;

/

Every time an additional (unwanted) indentation is added before NULL;. This worked fine with SQL Developer 19.4.0.

Same behaviour with multi-line comments. Same behaviour on macOS and Windows.

Any Idea how I can avoid this additional indentation with SQL Developer 20.2.0?

I hoped we get access to comment nodes in Arbori, based on this thread SQL Developer 19.2.1 - Custom format: line break on hints, columns/argument alignment . But it does not seem so, so I really have no idea how to change formatting when comments are involved.

Thanks

Philipp

P.S.

I use this settings:

sqldev-adv-formatter-settings.png
This post has been answered by Vadim Tropashko-Oracle on Jun 29 2020
Jump to Answer

Comments

LA County APEX

You can use a JavaScript to accomplish that. Check my application

Workspace: ladevapex

User Name: mydevfellow

Password: Pa$$word1

To test the application, follow the steps below:

  • Click Upload New Image button
  • Click Detail button
  • Enter or select the first row objects.
J.col

Hello.

Thanks for the answer and the application infos. I took a look and I learnt a lot of things !

For my issue, I checked your page 7 (detail button) and I didn't understand how it works. I think what I'm doing is very similar to your page 7, but I'm probably missing something.

Here is a part of my application.

pastedImage_0.png

When the user selects a date or a "New" value I want to update my right part with the selected info

pastedImage_1.png

For the moment, I created a PL/SQL process I duplicated in every concerned field.

As this is only a demo application with 4/5 fields, this is not a problem. But at the end, I'll have more than 30 distinct selection fields, and I cannot duplicate my PL/SQL process 30 times ^^

Can you explain me how you would do that please ?

Best regards.

LA County APEX
Answer

All you have to do is to call a JavaScript function to collect value from each item into your display list. Note, this is only to display to the user what being selected. When saving the record, you need to pass the actual value from each item to your process as a parameter.

The following example is the function on page 7 of my application.

function shwVal()

{

  $x('SELVAL').innerHTML = '';

  if ($x('P7_TXT1').value != '')

        $x('SELVAL').innerHTML = $x('P7_TXT1').value;

  var comm = '';

  if ($x('SELVAL').innerHTML)

       comm = ',';

   if ($x('P7_TXT2').value.length == 4)

        $x('SELVAL').innerHTML = $x('SELVAL').innerHTML + comm + $x('P7_TXT2').value;

    if ($x('SELVAL').innerHTML)

       comm = ',';

    $x('SELVAL').innerHTML = $x('SELVAL').innerHTML + comm + apex.item('P7_SEL').getValue();

    if ($f_SelectValue('P7_CHKBX') != '')

        $x('SELVAL').innerHTML = $x('SELVAL').innerHTML + comm + $f_SelectValue('P7_CHKBX');

    if ($x('SELVAL').innerHTML)

       comm = ',';

    if ($f_SelectValue('P7_RADIO') != '')

        $x('SELVAL').innerHTML = $x('SELVAL').innerHTML + comm + $f_SelectValue('P7_RADIO');

}

Marked as Answer by J.col · Sep 27 2020
1 person found this helpful
J.col

Hello !

I'm not familiar with Javascript and its integration into Apex so I didn't look at the good place.

With the search function, I was able to find your JS function and how you call it into your items.

A big thanks !

1 - 4

Post Details

Added on Jun 28 2020
#sql-developer
7 comments
1,451 views