Oracle SQL Developer
Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. Run your sql and sql scripts, manage users, create and edit objects, import data to new or existing tables, diagnose performance issues, visualize your schemas, and much more. The power of your favorite desktop tool, in your browser. Available with Oracle REST Data Services for your on-premises instances. Migrate Oracle On-Premises to Oracle Cloud. Click, browse, and managed the contents of your Oracle Database.
Learn more
SQL Fiddle
If you do not know SQL or basic database concepts, this site is not going to be very useful to you. However, if you are a database developer, there are a few different use-cases of SQL Fiddle intended for you. You want to compare and contrast SQL statements in different database back-ends. SQL Fiddle easily lets you switch which database provider (MySQL, PostgreSQL, MS SQL Server, Oracle, and SQLite) your queries run against. This will allow you to quickly evaluate query porting efforts, or language options available in each environment. You do not have a particular database platform readily available, but you would like to see what a given query would look like in that environment. Using SQL Fiddle, you don't need to bother spinning up a whole installation for your evaluation; just create your database and queries here!
Learn more
AI2sql
With AI2sql, engineers and non-engineers can easily write efficient, error-free SQL queries without knowing SQL. All you need to do is enter a few keywords about your data - AI2sql automatically builds an optimized SQL query for your data resulting in extremely fast performance. We wanted to share some exciting numbers with you about how many people have tried out AI2sql, and what they've been able to accomplish with it. To get the best results with AI2sql, it is important to clearly define your goals and use the tool's customization options, test and verify the generated SQL. You can also try changing the prompts or input used to generate the SQL statements to see if this results in more accurate or efficient queries.
Learn more
Visual Expert
Visual Expert is a static code analyzer for Oracle PL/SQL, SQL Server T-SQL, and PowerBuilder.
Identify code dependencies to modify your code without breaking your application.
Scan your code to improve the security, performance, and quality.
Perform Impact analysis to Identify breaking changes.
Automatically scan your code to detect and fix security vulnerabilities, bugs and maintenance Issues.
Implement continuous code inspection
Understand the inner workings of your code with call graphs, code diagrams, CRUD Matrix and Object Dependency Matrix (ODM).
Automatically generate an HTML Source Code documentation.
Explore your code exploration with hyperlinks
Compare applications, databases or pieces of code.
Improve maintainability. Clean up code. Comply with dev standards.
Analyze and Improve DB code performance: Find slow objects and SQL queries,
Optimize a slow object, a Chain of calls a slow SQL, Get a query Execution Plan.
And much more.
Learn more
