It’s been a while since the last update of dbForge Studio for Oracle, your go-to IDE when it comes to developing and managing Oracle databases. But today is the day that we finally roll out a few useful goodies we’ve prepared, including newly supported statements and a bunch of new formatting profiles to make your daily work with Oracle a breeze.
Support for CREATE, ALTER, and DROP VIEW statements
Let’s start our tour with code completion—namely, with the newly introduced support for CREATE VIEW, ALTER VIEW, and DROP VIEW statements. We believe they’ll definitely come in handy.
New formatting profiles
We’ve also enhanced the integrated PL/SQL Formatter with a collection of new predefined profiles (in addition to the already available Default and Quest Software Toad) that you can further customize to your liking. Take a look at what you’ve got now:
#1. Collapsed
#2. Commas before
#3. Compact
#4. Extended
#5. Indented
#6. MSDN SQL
#7. Quest Software Toad
#8. Right aligned
#9. Stack compact
You can view and configure formatting profiles in Tools > Options > Text Editor > Formatting > Profiles.
Include security permissions
Finally, we’ve augmented script generation with a new option called Include security permissions, which can be found in Tools > Options > Generate Schema Script > General > Generate Script AS. There, you’ll find this option among the General settings. Note that it is turned off by default.
Download dbForge Studio for Oracle v4.6 today!
That’s it for today, but there will surely be more and more pleasant surprises and new features up ahead! And now, we’d love to invite you to either download dbForge Studio for Oracle for a free 30-day trial or, if you already have it, get this update right now from the Help menu > Check for Updates. And, of course, feel free to share your impressions with us—your feedback helps us keep our products perfectly convenient and relevant for you.
Get the updated dbForge Studio for Oracle in a multidatabase suite!
We’d also love to remind you that if you happen to work with other database systems, such as SQL Server, MySQL, MariaDB, and PostgreSQL, you might as well try our suite called dbForge Edge, which comprises four Studios and offers a wide coverage of databases and cloud services. The updated dbForge Studio for Oracle is part of it.
