SQL Developer Reviews & Product Details - Page 12

What do you like best about SQL Developer?

1)As Oracle db do not have any interface SQL developer provide very easy and handy way to connect Oracle db

2)expecting and writing query is very simple

3) shows all types of exception while executing the query

4)formating of the query gives more visibility of the condition

6)we can also connect other database apart from oracle by adding plugins Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

1) sometimes it get hang while executing query.but this is fixed in latest version Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

It is fast and user friendly don’t have write full query with drop down feature. Very less chances of getting errors Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Did not found yet. Did not found yet.... Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

Free and easy to install.

Attractive GUI to work with.

Non-DBA user also can work with sql developer as in this writing sql queries is easier.

When there is any syntax or script error comes then it will gives you proper error message so that you can fix it.

Plus point is that you can import large sql files from your file systems.

While establishing connection to new database it is very easy.

Autosuggestions is also good feature.

Easily export schema and data from tables. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Performance is good,but when it comes to work with large data set it is little bit slow.rather than this nothing dislikes. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

It’s best graphical user interface to connect to oracle database servers.it provided auto suggestions feature which very helpful while framing database queries.no need write queries for data definition language script ,the tool it provided options and generates queries also.we can manga multiple connections in single window. Easily we can convert queries into sql query structure.we can export and import the data in different manners even we can the connection also Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

We can not run multiple sessions at time and IN query can not provide more than thousand records Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

It's free. Everyone likes free tools. The UI is quite simple, you will not need any manual to operate it.

The tool was used throughout my organisation. I used it in software testing. The fact that handle multiple data bases at one time and you can work with data very easily through queries directly makes it user friendly.

Exporting data is another useful feature to analyse data. This was required while we were making software from scratch and it was very helpful in root cause analysis.

Another simple yet useful feature is the color coding of keywords while writing sql queries.

You can also save your work into a sql file which can be used later.

From beginners to experts it's useful for all.

End user reports extraction using sql queries is very direct easy. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

There is nothing as such to dislike but sometime while running large set of queries it used to hang (running displayed always) and we were never sure that the changes were made or not. Anyway we have to execute the changes again which was a rework.

The UI is not customizable which is think is a feature present in many tools. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

SQL Developer is free and very easy to use to access a group of Oracle Database where I need to deploy scripts made by developers. Sometimes I need to look at their code mistakes and try to recompile their objects and it's really easy to do it with SQL Developer. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

When trying to save log output from the SQL Statements that I just run, it would be great if the last used directory was already selected. Apart from that I don't remember anything that I dislike about SQL Developer. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

You can add as many connections you want, creating a table or updating any table structure - variable type, size etc is just so easy with Oracle sql developer by just right click and edit.. / create table.. A Connection added is so well structured with tables, views, triggers,sequences, views, procedures, functions, etc Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The timeout span must be increased.. and there's no shortcut to switch between two connections. Also the export time is too large for a small file too.. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

We can save multiple session of different schema. We can view all table and user in the schema in a single window, can place request to view DDL which is generated automatically. Multiple queries can be made in a single window. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The SQL developer does not prompts with correct syntax if something is missed. If a query is killed it take lot of time to execute it. Unable to export data in the latest excel also very less format options are available to export. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Never know when a query has been truly terminated. Even if one has access to the SQL Monitoring or Monitoring SQL Sessions, it still may show as being terminated but in actuality, within OEM, the query could still be running and need to be killed there. The inability to truly know when a session has ended results in frustration because the next query may not be able to run because the last is actually still running.

The tuning advisor runs very long and is not always helpful.

Not knowing the status of a query can be frustrating. That is, if a query is running long, it may show as "running" (i.e. the horizontal bar moving back and forth at the bottom of the screen), but in actuality, it may be hung up. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

I enjoy sql developer for what it is. It's quick, easy to use, the layout makes sense, and it's not a super resource hungry. Switching between connections is quick and it offers a fair amount of functionality tailored towards DBAs. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

There isn't much to dislike really. One thing I would like them to add would be themes. Personally I enjoy the dark theme option from Microsoft products, I wish Oracle would adopt that. It's definitely not crucial functionality or anything, but a nice feature when all your other apps are dark and you're working at night. Review collected by and hosted on G2.com.