SQL Developer Reviews & Product Details

Best Things about SQL Developer:

1. It is easy to install and we can execute multiple queries in a single hit.

2. We can easily export table schema, views, indexes, etc.

3. Debugging is very easy so we can find bugs in our queries easily.

4. We can easily convert data to DDL queries. Review collected by and hosted on G2.com.

Dislikes:

1. It takes time to process long complex queries.

2. It takes a large amount of your RAM memory to process your queries.

3. A few times auto suggestions are not working properly in SQL Developer. Review collected by and hosted on G2.com.

I use SQL developer for my personal projects. Review collected by and hosted on G2.com.

Oracle SQL Developer drops the DB sessions more often than other counterparts. Review collected by and hosted on G2.com.

I have been used SQL Developer in my project since 2017. It is the best tool for handling a relational database. It is easy to use and also the user interface of the tool is appealing as well. There are lots of features provided SQL Developer for example easily defines a clustered index, a lot of support and documentation, a stable tool with fewer errors, etc. Review collected by and hosted on G2.com.

Currently, i use SQL Developer for my web application development. I would like to suggest some area of improvement need to be consider by SQL Developer team like needs improvement in user interface,newer version of SQL Developer some performance issues and also database backup mechanism need improvement as well. Review collected by and hosted on G2.com.

Data is organised by the relationship between the tables.

Can process multiple queries in a single transaction.

RAC allows to work on same database from different servers.so,By this way it cuts the cost of maintaining an additional server.

It's a highly specialized language.

Debugging a query is very easy.

Finding in the bugs is very easy using debugging.

It provides proper Exception.

It allows us to export and import the text, spreadsheet and CSV files.

Exporting table schema, sequences,indexes,views, triggers is very easy.

Converts the data in the form of DDL query. Review collected by and hosted on G2.com.

Cost is very high.

Cannot operate more than 1000 elements in an IN clause.

Incapable of executing recursive processing.

Data incompatibility and inconsistency in terms of date and time syntax.

Takes time when the query is complex. Review collected by and hosted on G2.com.

1.It is very user friendly.

2.One can easily understands it.

3. It is Easy-to-understand errors and explanations on incorrect queries.

4.Finding tables and Views more easily.

5.It is easy to find errors when debugging.

6.It is Easy to run scritps.

7.we can create tables,add columns without using queries by using user interfaces it can be done.

8.We can Import DATA easily from text files, Excel files, and CSV files.

9.We can export data to excel files as well. Review collected by and hosted on G2.com.

1.If the Data is more it takes take to fetch the data.

2.Some times when we write query like "select * from tablename where " after where if we press ctrl+space it doesn't give suggestions of columns.

3.SELECT DISTINCT REGEXP_SUBSTR ('23,34,45,56','[^,]+',1,LEVEL) as "token"a

FROM DUAL

CONNECT BY REGEXP_SUBSTR ('23,34,45,56','[^,]+',1,LEVEL) IS NOT NULL

order by 1 for this query if we pass more than 300 input as comma separated it throws error.

4.We can't run more than one query against the same database at one time.

5.SQL Developer uses large amount of RAM. Review collected by and hosted on G2.com.

1.It is a very good product to store,process,manage the information.

2.Simple UI, which is easy to understand even for begineers.

3.Most of the operations can be done without writing queries like creating tables,add,delete,update,add constraints etc..

4.It introduced the schedulers ,java and xml also. Review collected by and hosted on G2.com.

1.It uses Large amount of RAM.

2.It runs as background process even if we close it.

3.It takes time to fetch data when data is more.

4.If the data is very huge sometimes takes time to fetch data.

5.I encountered a few times Auto suggestions didn't show properly.

6.SELECT DISTINCT REGEXP_SUBSTR (x','[^,]+',1,LEVEL) as "token"

FROM DUAL

CONNECT BY REGEXP_SUBSTR (x,'[^,]+',1,LEVEL) IS NOT NULL

order by 1 it gives error if we pass more than 350 elements in x. Review collected by and hosted on G2.com.

Flexible GUI. The UI updates of the latest version have made navigating through the various features of Oracle SQL Developer quite easy. Great Tools for Testing and Developing SQL Scripts. SQL scripting can be a hassle when working with large tables and such. Oracle SQL Developer makes it easy to preview how many rows and tables will be affected. Ability to Load Data from Different File Formats. Some of our data comes in the form of Excel spreadsheets, XML, and JSON. Oracle SQL Developer allows our database administrators to easily push the data from these formats into our database tables automatically. Review collected by and hosted on G2.com.

Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas.

Detailed analysis of models can be clunky for complex relational models. Review collected by and hosted on G2.com.

easy to use and connect. many tools in one place also integrated with all software of oracle Review collected by and hosted on G2.com.

not fully user friendly software. not everything easy to drag and drop Review collected by and hosted on G2.com.

Easy DML as well as DDL operations.Trigger as well as sequence creation are very simplified.Compile time accurate reasons for error .very convenient in extracting DDL for tables and extracting,Export of resultSets is very feasible.Sql Script genration as well as unit query execution are very handy. Review collected by and hosted on G2.com.

Stuck query status in case of heavy load.Parallel threads in query execution is not allowed sometimes.Lacks SQL session monitoring and managing capablities Specially in case of large result sets. Review collected by and hosted on G2.com.

I like its basic functionalities which is really intuitive. It produces an easily readable view of the SQL scripts being written with debugging suggestions clearly marked like it auto-completes the object names while writing SQL script. It easily produces explain plan results(cost) for any SQL script. Review collected by and hosted on G2.com.

Default settings should be easier to set such as keeping the line numbers in view at all times. Resource manager and storage(DBA utilities) are can be improved. Review collected by and hosted on G2.com.