Notepad++ vs. Oracle SQL Developer

well suited for 1) Coding and Development - Writing and editing code, Quick prototyping and testing of code snippets, Debugging and inspecting code using syntax highlighting and line numbering, 2) web development - Creating and editing HTML, CSS, JavaScript, and other web-related files .Managing and organizing web projects with multiple files and directories. Not suited for - 1) processing huge files 2) graphic designing 3) complex gui designs 3) Data Analysis and Manipulation - Editing and cleaning up text-based data files before importing them into analytical tools. Applying regular expressions to extract, transform, and manipulate data. 4) System Administration and IT - change system configuration file

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.

It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Notepad++ allows us to keep open files in tabs. Like in a web browser, these tabs let us access these files quickly and easily. Furthermore, even if we forget to save the files when closing the program or shutting down the PC, Notepad++ retains them in the open tabs when we reopen it.
• Notepad++ supports many different file types. We usually save our files created in Notepad as normal text files, but sometimes as JSON, PHP, and HTML files.
• Notepad++ is lightweight and requires little resources. Using it is snappy and responsive.
• The developer of Notepad++ frequently updates the software with bug fixes, performance improvements and new features.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
• The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
• DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• UI looks a bit dated.
• Sometimes the number of options are overwhelming and require a quick search to figure out where to locate a particular function.
• Some way to do a diff between files would be great. Still need to resort to another paid app for that - unless it is a buried function I don't know about or there's a plugin for it.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Inability to run multiple queries on the same database. You can only run one query on a given database.
• Analytical models created from complex tables isn't accurate, and needs work.
• Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info

I use it every day for 13 years already and it never disappointed me

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

There are lot of features to talk about. Especially the usability is good. Everyone can easily to use and user-friendly. Can also update easily. Can also write and execute the programming languages like C, C++ etc. Encoding is also the major feature that helps me a lot and converter as well.

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

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

I haven't needed to utilize any support related to Notepad++. I guess this is a good thing because I found it to be quite intuitive. There are almost infinite features you can tweak and plugins you can download but I haven't had to do that because Notepad++ is really good right out of the box.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Large user community support

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info

Just download and uncompress!

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Notepad for Windows, Microsoft Word...LibreOffice Writer....I have used all of these for code writing and editing. Once again I like the universal feel of Notepad++. Basic Notepad, is just that, basic...and kind of clunky for what it is. This is a cool that I have installed on all my computers and also keep it on a thumb drive if I need it elsewhere.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Productivity has increased for developers.
• It's free so instead of buying a piece of software, you can use this to replace many of them that may only specialize in one thing.
• It gives our developers confidence knowing they have such a reliable, free tool at their disposal.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• It gives 100% return on investment as it is free of cost.
• No need to have multiple tools for each database
• Considering the employee training, so one can save money on training, as it is not very hard to use so still savings.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info