S
S
Sophie_2092014-11-23 19:33:47
SQL
Sophie_209, 2014-11-23 19:33:47

What is more convenient and practical to use for working with databases (SQL / Pl SQL)?

I used SQL Developer and PL/SQL Developer to work with ORACLE DB and PL/SQL. In my opinion, it is more convenient to work with SQL Developer. They also advised TOAD, but I didn’t have to deal with it myself.
Maybe some of the above have significant advantages, I would be grateful for advice.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
T
TheRL, 2015-11-10
@TheRL

TOAD is great for the admin, viewing sessions, current requests and the values ​​that are passed to them.
PLSQL Developer does a great job at optimizing queries. For some reason, sometimes everything goes faster through it. Debug and Test are great things.
I use the usual free Oracle sqldeveloper mainly because it’s nice to write code, there are all admin functions, a lot of database monitoring, and in general it’s good for absolutely everything, except that it crashes and hangs more often than other IDEs, but you just need to be able to use it so as not to lay down) However, other IDEs infuriate me specifically with their code design, fonts and other things inherited from mammoths.
I always have sqldeveloper and PLSQL Developer open to run large queries and test. Together, they speed up my work.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question