SQL Developer Reviews & Product Details - Page 11

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

1. Best tool to administrate you database.

2. We can create tables, update the data without writing queries.

3. We can create reports for data analysis and to form charts and graphs.

4. We can migrate our db through sql developer.

5. We can create sequences, cursor and triggers.

6. We have the functionality of OWA Output.

7. We can connect to cloud databases.

8. We can connect our database on git from Sql Developer.

9. We can export the tables and data into excel file.

10. We can manage rest data services connections. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

1. While applying filters on a column sometimes becomes more time consuming than expected.

2. Loading time is more when we sort the table in ascending or descending order. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

Oracle database is SQL database.It support RAC and Non RAC database.SQL database is easy to handle than non SQL database. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Something when connectivity gets disconnected it gets stuck up on that page only and doesn't respond. And sometimes the stored procedures are not visible due to version problems. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

I use sql developer in company in which I'm working and in my various college projects.

I found it really useful and it has various key benefits. Apart from performing basic crud operations there are many features which it gives us such as it can export data to various formats, With help of SQLtunIng it gives us Query Performance, It provides us tree like structure to insert data or create table, etc. And there are countless features in Sql developer Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Till date I haven't find any issue because of which i should comment about software.

I really enjoy working on SQL DEVELOPER. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

From basic queries to testing and development SQL scripts are convenient.Preview of tables and rows affected are very helpful.Report export in desirable format like excel spreadsheet comes in handy.Multiple connections can be handled very smoothely as well as creation of views ,triggers,procedures are easy . Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Dealing with large data sets are not upto mark.Session monitoring capablity and management are not upto mark.Accesing database object like indexes are not that good.Query execution get stuck sometime and creates confusion between running or stuck status. Review collected by and hosted on G2.com.