Oracle SQL Developer vs. Sublime Text

[Oracle SQL Developer is] best suited if your company works with different databases and needs a common SQL editor to manage and query data for its user. Oracle SQL Developer works very well with Oracle but also some other relational databases. If you do lot of querying and import/export in database, then this is tool for you. It's ideal for DBAs as well for data modeling, management, session monitoring, logging, versioning, etc. It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.

Incentivized

My CMS has a small window in which I can edit custom HTML/CSS. It can be expanded some, but not as much as I would like. It also displays all code as dark text on a white background. On a page where I am doing extensive custom coding, it is helpful to see it in a larger window and in a color-coded display so that I don't have to strain my eyes as hard. Especially when I'm trying to scan for specific elements and target issues and so that I don't have to scroll endlessly in a tiny window.

Incentivized

• Export SQL results to a spreadsheet. After a query is run, you are able to export the results to a spreadsheet
• Easily preview data columns on an Oracle table or view and the metadata on those columns.
• SQL Editor is color-coded so that you can tell easily what are keywords.
• You can set up SQL code templates to be able to use shortcut keys to format your SQL query easily in a readable format that you prefer.

Incentivized

• Sublime Text does an incredible job with appropriate color coding and syntax definitions; makes code extremely readable
• Tab selection is very well done; easy to see which files have been changed and to compare across multiple files
• Auto-complete is surprisingly effective and accurate
• Support for Apple M1 processors already

Incentivized

• 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.

Incentivized

• In a world of free and open text editors, Sublime Text does ask for donations. You can use the product freely with only a very infrequent popup asking for donations. You can use it however long you like without paying, but it is well worth it to donate to.
• People not used to the functionality may need a bit of time to get up to speed using the documentation.
• An integrated terminal would be nice, but that is just a quibble. It's hard to find many cons with Sublime Text.

Incentivized

It allows most users to perform daily activities in a simple way, with no cost since the tool is free.

Incentivized

I love this application. It has helped to improve my work. Also, I became so used to the shortcuts that It's hard for me to change to another editor.

Incentivized

Oracle SQL Developer is very easy to use and there are a wide range of courses available which can help you get started just within a day. Data can be exported in multiple formats based on user requirements. Organizational data can be stored and management effectively using Oracle SQL Developer. All the data, tables, sequences, indexes can be easily created and updated in Oracle SQL Developer.

Incentivized

This is a programmers tool. As such a lot of the features and benefits are lost on a non-technical user. To get the most out of the tool you need to have a basic crash course in how it works and what it can do. The documentation and community are good, but it takes a bit of time to get up to speed.

Incentivized

It has many handy hacks and shortcuts which enhances its performace.

Incentivized

Large user community support

Incentivized

Never had to use their customer support before. There is ample documentation online so it's straightforward to find a solution to any problem you might encounter. For example, I needed to convert a string of HTML code to a properly formatted HTML file to "modify." Easy to do when there are so many users of the product who have needed to do that same thing before.

Incentivized

Just download and uncompress!

Incentivized

Oracle SQL Developer is available on multiple platforms, Windows Mac Linux and it's free. SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage and develop Oracle Database in both on premise and Cloud deployments. SQL Developer can also connect and interact with non oracle database like MS SQL server and MySQL etc.

Incentivized

Sublime is more customizable and one can easily modify a lot of its features. On the contrary Visual Studio only has limited customizability features. Sublime text is also very light and not bloated as opposed to Visual Studio IDE. We also chose sublime because it has much better support for the majority of languages(especially Python) and I primarily work with python.

Incentivized

• No impact on the organization's budget as Oracle SQL Developer is free.
• With the increased productivity of our database administrators, they are able to better assist the software developers in prototyping future products.
• Through Oracle SQL Developer, our administrators were able to normalize many of our databases, reducing the amount of redundancy, and hence increasing the performance of our main application.

Incentivized

• Sublime is a cost-effective option for the company, as it isn't prohibitively expensive, and our team prefers it to other options.
• Speed, customization, and scalability are just some of the advantages of using Sublime Text in our IT department.
• Our work has been slowed down by faster coding and more accessible debugging apps, both good and bad.