When comparing dbForge Studio for Oracle vs Intellij IDEA, the Slant community recommends dbForge Studio for Oracle for most people. In the question“What are the best database clients?” dbForge Studio for Oracle is ranked 1st while Intellij IDEA is ranked 3rd. The most important reason people chose dbForge Studio for Oracle is:
Has full IDE features for PL/SQL such as: - Automatic code completion - Code snippets - Quick information on schema objects - Document outline for navigation - Smart formatting of SQL code
Ranked in these QuestionsQuestion Ranking
Pro IDE features
Has full IDE features for PL/SQL such as:
- Automatic code completion
- Code snippets
- Quick information on schema objects
- Document outline for navigation
- Smart formatting of SQL code
Pro Oracle PL/SQL Debugger
Pro You can execute stored programs step-by-step
Using the PL/SQL debugger you can execute queries step-by-step. Using breakpoints, evaluating and modifying variables or by analyzing the active stack of your PL/SQL program.
Pro Great overall functionality
dbForge Studio offers a very complete set of features.
Pro Has an easy to use object manager
Pro Very complete refactoring function
dbForge has a very complete refactoring function that leverages their dependency capability. Change a column name or attribute and it is reflected throughout the entire design.
Pro Query Builder
Pro Great dependency analysis and refactoring functions
dbForge has great dependency analysis and refactoring functions. Each object, whether table or view, has a child object that is the list of all other objects that reference the table or view in question. Indispensable for large database design.
Pro Can deploy an entire project or only the required changes to the server
Pro Manages different database versions
Pro Query profiler
You can find any issues that slow down your queries using the query profiler. Once you detect these issues you can change your SQL and optimize the queries.
Pro Great data manipulation features
Pro Schema Import/Export
Pro Oracle database management
Pro Support for JSON data
Pro Support for Google Sheets
Pro Documenter feature for documenting and presentation of the Oracle schemas.
Pro Data generator feature
Pro Fast and smart contextual assistance
Uses a fast indexing technique to provide contextual hints (auto-completion, available object members, import suggestions).
On-the-fly code analysis to detect errors and propose refactorization.
Pro Free version available
There is a free community edition (open source) and an ultimate edition, which you can compare here.
The ultimate edition is available for free for one year for students but must be registered through an .edu e-mail account.
Pro Intuitive and slick UI
IDEA has a clean, intuitive interface with some customization available (such as the Darcula theme).
Pro Stable and robust
IntelliJ IDEA hardly ever crashes or has any issues that plague other Java IDEs like file corruption or slowness.
Pro Support for many languages
IntelliJ supports many languages besides Java, some of these are: golang, Scala, Clojure, Groovy, Bash, etc...
Pro Smart refactorings
IDEA places an emphasis in safe refactoring, offering a variety of features to make this possible for a variety of languages.
These features include safe delete, type migration and replacing method code duplicates.
Pro Lots of plugins
Many plugins are available for almost any task a developer may need to cover. Plugins are developed by Jetbrains themselves or by 3rd parties through the SDK available for writing them.
Pro Android support, JavaEE support, etc
A very complete development environment support.
Pro Clear and detailed documentation
The documentation is exhaustive, easy to navigate, and clearly worded.
Pro Very powerful debugger
With ability to step into a certain part of a large method invocation (Shift+F7), drop frame, executing code snippets, showing method return values, etc.
Pro Many convenient features
These simplify the daily work, e.g. copy/cut a whole line without the need to select it.
Con Bugs are not solved as often as they should
They are more interested in adding new features or issuing new versions than solving bugs.
Con Somewhat expensive
IntelliJ IDEA is fairly expensive, with a pricetag of $149/year.
However there is a free community edition available.
Con Built with closed source components
The version with full features is not opensource. Parts of the code are under apache licence though.
Con Lack of plugins
IntelliJ supports a very small amount of plugins. Althrough thesse are 'quality approved', many features are missing and can't be implemented because of that.
Con Standard hotkeys behave differently
Seems like hotkeys assignment in Idea has no logical consistency.
Like «F3» is usually next match, «Ctrl+W» - close tab, etc — they map to some different action by default.
There is a good effort in making the IDE friendly for immigrants from other products: there are options to use hotkeys from Eclipse, and even emacs. But these mappings are very incomplete. And help pages do not take this remapping into account, rather mentioning the standard hotkeys.
So, people coming from other IDEs/editors are doomed to using mouse and context menus (which are rather big and complex).