Please tell us who uses what tools to work with PL / SQL code? I have been using Oracle's company for such tasks for a long time, but many things do not suit it: the lack of normal code highlighting, constantly falling off connections, and many more trifles.

Maybe there are better tools (programs) that make life easier for a developer?

PS Preferably free products, because the workstation is corporate

Closed due to the fact that it is necessary to reformulate the question so that it was possible to give an objectively correct answer by the participants ߊߚߤߘ , Suvitruf ♦ , Regent , mymedia , AK ♦ 14 Oct '17 at 14:47 .

The question gives rise to endless debates and discussions based not on knowledge, but on opinions. To get an answer, rephrase your question so that it can be given an unambiguously correct answer, or delete the question altogether. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • use toad - jmu
  • @jmu paid, not? - sonniy
  • dbForge convenient, but it seems not for commercial use - Valeriy Karchov
  • @sonniy used to be paid for corporate use only. In addition, it has a free eclipse plugin - jmu

7 answers 7

Apparently Oracle SQL Developer personally somehow unstable for you. It is very simple and convenient, not like PL / SQL Developer and TOAD, where a lot of unnecessary junk.

Keep using Oracle SQL Developer !

    I use NOTEPAD ++. Customizable lights and lots of useful things.
    NP ++

    • one
      And what, they can connect to the database server and execute queries? - msi
    • @msi, generally speaking - it is possible, but not very convenient - there is a call to an external program on an open file - you can connect a call to sqlcmd. The rest - just as an editor. - minamoto

    I use vim - it works on all platforms, everything is configured. If something does not work, you can fix it because all the functionality in the plugins or scripts. In the standard package there are the most necessary plug-ins - syntax highlighting, auto index, etc. - to work with pl / sql.

      I use SQLTools. It is free. There is nothing to compare with, because did not use others.

        The most popular we had were TOAD and PL / SQL Developer - both paid.

          Free for non-commercial use of DBForge , try to look, but I personally use SQL Developer .

            At work I use PL / SQL Developer. It is paid, but much better than SQL Developer. SQL Navigator was used in the previous place. Also paid. Both programs are much, much better than SQL Developer. SQL Developer compared to them a complete disappointment.

            From despair, you can get by with SQL Developer, but it's better to try something else. I strongly advise.

            Worked somehow in Oracle Forms - such a fucking program for developing forms for interacting with Oracle. Then did interfaces and some logic on Delphi using OCI for Oracle - the sky and the earth. One gets the impression that in Oracle the main developer forces are thrown on the development of the server side, they are doing pretty well. With client they have specific problems.