Forum Stats

  • 3,770,505 Users
  • 2,253,129 Discussions
  • 7,875,490 Comments

Discussions

SQL Developer 19.2.1 - Custom format: Align procedure/function parameters with below the brackets

User_ASUC3
User_ASUC3 Member Posts: 2 Green Ribbon
edited May 7, 2021 11:48AM in SQL Developer

Hi,

We have a requirement to align the functions and procedures in the below format.

i dont have much knowledge about arbori coding.

I Would appreciate any help here.

Answers

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,094 Employee

    first thing is to update to 20.4 and give that a try, there are already option avail for aligning pl/sql arguments...

    User_ASUC3
  • User_ASUC3
    User_ASUC3 Member Posts: 2 Green Ribbon

    I think my post was not clear , so i have attached a screen shot for the format i want.

    @thatJeffSmith-Oracle Thank you for the response. I tried with 20.4 version as well but it offered the same as 19.2. Only thing was the arbori editor was more user-freindly in 20.4

  • Vadim Tropashko-Oracle
    Vadim Tropashko-Oracle Posts: 1,243 Employee
    edited May 10, 2021 5:08PM

    pairwiseAlignments5_0: 

     [predecessor) '('

    & [node) prm_spec

    & predecessor=node-1

    ;

    ...

    pairwiseAlignments: 

      pairwiseAlignments00

     | pairwiseAlignments0 

     | pairwiseAlignments1 

     | pairwiseAlignments2 

     | pairwiseAlignments30 

     | pairwiseAlignments3 

     | pairwiseAlignments4 

     | pairwiseAlignments5_0 

     | pairwiseAlignments5 

     | pairwiseAlignments6 

     | pairwiseAlignments7 

     | pairwiseAlignments7_3 

     | pairwiseAlignments8 

     | pairwiseAlignments9 

     | pairwiseAlignments9_1 

     | pairwiseAlignments10 

     | pairwiseAlignments11 

     | pairwiseAlignments12

    ->

    ;