Welcome to Oracle SQL Developer.
Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, edit and debug PL/SQL statements, manipulate and export data, and view and create reports. You can connect to Oracle databases, and you can connect to selected third-party (non-Oracle) databases, view metadata and data, and migrate these databases to Oracle.
SQL Developer also integrates interfaces into several related technologies, including Oracle Data Miner, Oracle OLAP, Oracle TimesTen In-Memory Database, and SQL Developer Data Modeler (read-only).
1Oracle® SQL Developer User's Guide Release 4.0 E38414-09 October 2014 Provides conceptual and usage information about Oracle SQL Developer, a graphical tool that enables you to browse. SQL Developer, August 2012–September 2017. Utilized Joins and sub-Queries to simplify complex queries involving multiple tables while optimizing procedures and triggers to be used in production. Performed SQL, PL/SQL, and application tuning using multiple tools like EXPLAIN PLAN, SQL.TRACE, TKPROF, and AUTOTRACE. In SQL Developer, if you run a statement that has any number of bind variables (prefixed with a colon), you'll be prompted to enter values. As Alex points out, you can also do something similar using the 'Run Script' function (F5) with the alternate EXEC syntax Alex suggests does.