Now I try to create packages in an oracle. He singled out a group of procedures and functions and put in one package. And then he thought. I used to have all the procedures were separate tabs. And now I got one packet on a dozen screens and the readability of the entire code has plummeted.

The question is, is it the cost of my IDE (EMS Oracle Studio), which shows all the procedures in solid text, or does all the IDE work this way? If everything is, are there any ways to improve the readability of the package? Insert any visible comment delimiters?

    1 answer 1

    In general, all IDEs show the code in solid text. Or did you mean code navigation and syntax highlighting?

    I now have only Oracle SQL Developer, there is a backlight, and navigation:

    enter image description here

    You can click on the left of the name and transmute into the package, the package body or to a specific function inside. The procedure in the code has a blue arrow - on it you can move from the announcement to the body and back. Folding / expanding the code too. Go to ctrl+click , code completion, and more.

    I personally like PL / SQL Developer a lot more (there are more functions, and they are better implemented), but it costs money, and employers are greedy. Of course, compared to Intellij IDEA, these are all dinosaurs, but you can work.

    • Thank. The idea is clear. I have no navigation either. But what about Intellij IDEA? Does she really know how to work with Oracle? I thought this IDE is purely for programming languages - Anton Shchyrov
    • It can work a bit with the database, but I talked about its capabilities for working with Java. Just a spaceship compared to what is in the top tools for oracle. - Dmitriy
    • Clear. So in orakle, really so sad. I work with IB / FB / MySQL - there the tools are an order of magnitude more adequate. Thought I don’t know - Anton Shchyrov