As an SQL developer I really like to play with data. It is good and easier to use SQL . The best part in SQL is it's syntax and UI which we can use and can build good projects. Review collected by and hosted on G2.com.
As such I like nothing about sql it's easier to use some time there is connection issue which occurs and it's not an big deal I think. Review collected by and hosted on G2.com.
User friendly interface, shortcuts and options to handle the sql code Review collected by and hosted on G2.com.
Sometimes take time to open and run the queries. Everything is fine other than that. Review collected by and hosted on G2.com.
SQL developer is most powerful and popular tool built by Oracle .There are many editions free to licenced version so that a large number of users can use the same . It manly used for Database integration , and it supports many vendors. We can export data , execute certain plan and fetching table data in our own required formats . We can see the time taken also . For big queries SQL developer is very helpful because it gives hierarchy lines to understand in different colors . Review collected by and hosted on G2.com.
There is nothing to dislike and no cons found as such about SQL developer. This amazing tool is good for everyone who want to access database and see table format , space of the cluster. The easy implementation makes easier for any vendor to integrate with it.Oracle itself having very good customer support system for its own products which is good for any company to choose and implement in the project. Review collected by and hosted on G2.com.
SQL developer is so easy to use and at the same time have all the functionalities you need to work with databases like setting up database connection, user security and especially the workbook so easy and efficient lets you write your query and also suggest auto completion. You can select what you want to run and see result at the same time. All I can say is if you want to work with SQL this is the tool you should use. Review collected by and hosted on G2.com.
Sometime setting up the connection can be a bit of a task and the complex big queries takes some to run and show result. Review collected by and hosted on G2.com.
It has many options, easy to us UI. The tab system is done well and there are many DBA functions that can be used through the tool like checking tablespaces, currently running jobs and running execution plans for queries.
There is a DBA window that you can attach a connection to and if you have full DBA rights, then you can perform your functions via a UI instead of having to type them in a command prompt Review collected by and hosted on G2.com.
It uses a lot of resources and it can sometimes just crash. When I try to remote into my work computer from home, sometimes the SQL Developer just closes itself. It gives no warning. Never had that issue using Toad.
I also havent been able to locate the table locks and which sessions are causing those locks at the moment. I hope to be able to find that functionality soon. Review collected by and hosted on G2.com.
SQL Developer simplifies database management, making it easier to create, edit, and maintain database structures. Its efficient SQL query development tools streamline data retrieval and manipulation tasks. SQL Developer offers strong reporting and data visualization capabilities, aiding in data analysis and reporting tasks. Review collected by and hosted on G2.com.
A potential drawback of SQL Developer is its relatively steep learning curve for beginners Review collected by and hosted on G2.com.
SQL Developer is very easy to install, setup and integrate with existing databases. I use it almost everyday. I really like the play button that is used to execute the procedures and packages without having to write additional blocks of code. There are buttons to clear your query screen and your output screen that are very helpful. Review collected by and hosted on G2.com.
Multiple settings are needed to configure Format option. It would be better if they provided few templates to choose with preview rather than these settings. Review collected by and hosted on G2.com.
User Friendly Interface,SQL Coding and Editing,Database Administration tools & Integration with Oracle products Review collected by and hosted on G2.com.
It's an intensive resource with a steep learning curve and have limited non-oracle database support Review collected by and hosted on G2.com.