Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
It is suitable for making portable applications, with almost the same code for several platforms. You can access native features of the device or use an open source plug-in from the repository to create a local database and access the internal storage of the device. It is wonderful for the construction of a native application, through the use of standard web code. It is not recommended for enterprise applications.
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.
Adobe Phone Gap has an extremely simple user interface that allows for easy learning to occur.
Adobe Phone Gap provides support for web languages and allows you to write in three of the main languages and transfer them to another language for use. This solves a common programming issue and is the greatest strength of the software.
Their desktop application allows for easy installation and programming.
Adobe provides quick support with questions about how to use the software.
The build interface notifies you of errors extremely quickly and helps identify the issue in your programming. You get an easy idea of what needs to be updated and adjusted.
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.
Cordova app code runs inside a webview component. So, expect the performance to be a little slower as compared to the native apps. This is more noticeable on older devices though. It is hardly noticeable when it comes to newer mobile devices.
Crashes can be hard to debug since the crash logs will not point you to the culprit javascript code. This is not a limitation of Cordova alone. Any other hybrid mobile app development platform suffers the same problem.
Even with tools like Safari debugger and Chrome debugger, it can be tricky to measure graphics and animation performance. Achieving smooth animations can be a bit of a challenge sometimes with hybrid mobile apps in general.
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.
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.
Apache Cordova is the mother of all other frameworks. The Ionic developed framework is well suited for development but most of their features are offered by paid services. As Apache Cordova is open source and has a license to modify it, it has no legal problems to work with it. Also, most well-known IDEs recognize the Apache Cordova snippets.
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.
