SQL Developer AMI

This is a repackaged software product wherein additional charges apply for cloudimg support services.

Overview

Oracle SQL Developer is a free, integrated development environment for Oracle Database. This AMI provides SQL Developer pre-configured on Windows Server, enabling database administrators and developers to manage Oracle databases, develop PL/SQL code, model data, and perform migrations with a comprehensive IDE.

PL/SQL Development

Complete IDE. Code editor with syntax highlighting. Code completion. Compile code. Debug procedures. Set breakpoints. Step through code. Watch variables. Test programs. Stored Java support.

SQL Worksheet

Run queries. Execute scripts. Execution plans. Result formatting. Export to XML, Excel, HTML, PDF, CSV. Custom formatting.

Database Administration

DBA console. Browse objects. Manage schemas. User and role management. Privileges. Performance monitoring. Security config. Database settings. Session management.

Data Modeling

ERDs. Visual modeling. Create from schemas. Forward and reverse engineering. Model validation. Documentation. Collaboration.

Database Migration

Migrate third-party databases to Oracle. Migration scripts. Data type conversions. Schema conversion. Data transfer. Validation. Reports.

RESTful Services

Develop REST APIs. API testing. Service deployment. OAuth support. Authentication. API documentation. Service monitoring.

Database Browser

Object browser. Table, view, index browsing. Constraints. Triggers. Sequences. Synonyms. Packages. Functions and procedures.

Query Tools

Query builder. Visual design. Query optimization. Explain plans. Query tuning. Performance hints. Index recommendations. Query history.

Data Management

Import and export tools. Bulk operations. Data transformations. Validation. Data cleansing. Table editing. Grid editing. Filters.

Version Control

Subversion and Git integration. Version control for objects. Schema versioning. PL/SQL versioning. Compare and merge schemas. Branching.

Debugging Tools

PL/SQL debugger. Breakpoints. Step execution. Variable inspection. Call stack. Watch expressions. Debug output. Exception handling. Remote debugging.

Performance Tools

SQL tuning advisor. Performance monitoring. Execution statistics. Real-time monitoring. Wait events. SQL trace. AWR reports. ADDM reports. Dashboards.

Reporting

Built-in reports. Custom reports. Report templates. Database stats. Performance reports. User reports. Object reports. Scheduling. Export.

Schema Tools

Schema comparison and sync. DDL generation. Object DDL export. Schema export and import. Creation wizards. Table and view designers.

SQL History

Command history. Query history. Search. Rerun queries. Management. Export and import. Filters.

Windows Integration

Windows Server 2019. Windows authentication. Active Directory integration. Windows service integration. Event log support. PowerShell compatibility. Remote Desktop port 3389. Windows Explorer integration.

Oracle Database Support

Oracle Database 11gR2. Oracle Database 19c. Oracle Database 21c. Oracle Database 23ai. Oracle Cloud support. On-premises support. Multi-version compatibility.

cloudimg Support

24/7 support via phone, email, chat. SQL Developer configuration assistance. Database connectivity guidance. Performance optimization. Migration support. Troubleshooting. Best practices. Rapid response.

Use Cases

PL/SQL development. Database administration. Data modeling. Database migrations. Performance tuning. SQL query development. Report generation. RESTful API development. Schema management. Database monitoring.

FAQ

Q: Which SQL Developer version?

A: Latest with desktop interface and full IDE.

Q: Oracle Cloud database support?

A: Yes, Cloud and on-premises.

Q: PL/SQL development?

A: Yes, complete IDE with debugging.

Q: Database migrations?

A: Yes, third-party to Oracle migration.

Q: Data modeling?

A: Yes, ERD creation and modeling tools.

Q: Oracle version compatibility?

A: Yes, 11gR2, 19c, 21c, 23ai supported.

Q: RESTful services?

A: Yes, development and testing tools.

Q: Performance tuning?

A: Yes, tuning advisor and monitoring.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.