SQL Developer

What is SQL Developer

Oracle's SQL Developer is a tool provided by oracle to enhance productivity 

by simplifying database development tasks.

In simple words its a graphical tool used to execute our SQL Statements and view the results with many additional features.

Main Features:- 

Browse and Manage DB objects

Executing SQL Scripts

Editing and debugging PLSQL code

Reporting

In our course we have executed all the scripts on SQL Developer.

You can download SQL Developer from Oracle's official site (Free).

SQL Developer supports Oracle Database 10g, 11g, and 12c and will run on any operating system that supports Java.

Developer Use

SQL Developer provides powerful editors for working with SQL, PL/SQL, Stored Java Procedures, and XML. Run queries, generate execution plans, export data to the desired format (XML, Excel, HTML, PDF, etc.), execute, debug, test, and document your database programs, and much more with SQL Developer.

DBA Use

SQL Develper isn't just for developers! Since version 3.0, the DBA Panel (available under the View menu) has provided database administrators a set of interfaces for their most critical tasks. SQL Developer will continue to add and enhance features for the DBA. Today,  SQL Developer's DBA panel provides support for:

• Data Pump
• Recovery Manager (RMAN)
• Oracle Auditing
• User and Role management
• Storage management, including the ability to add space to your tablespaces
• Resource Manager
• Diagnostic Pack features:
  • Snapshots
  • Baselines
  • ADDM
  • ASH
  • AWR