Administering the Database with SQL-Based Management Tools

Oracle Database Administration with SQL-Based Management Tools

Oracle tools such as SQL Developer and SQL*Plus are used to administer your database.

These tools help to perform database management operations, and to query, insert, update, or delete data directly in the database.

About SQL :

SQL is a powerful language that can also be used to perform a variety of database administration tasks.

Like,
Creates the database user Vivek and assigns him a password of your choosing, represented by password:

CREATE USER Vivek IDENTIFIED BY password;

Lists information about countries in a countries table, which is owned by user hr:


SELECT COUNTRY_ID, COUNTRY_NAME FROM HR.COUNTRIES;

About SQL*Plus :

SQL*Plus is a command-line program that you use to submit SQL and PL/SQL statements to an Oracle database.

SQL*Plus is installed with the database and is located in your ORACLE_HOME/bin directory.

You must end each statement with a semicolon (;).

Starting SQL*Plus and Connecting to the Database

To start SQL*Plus and connect to the database from the command line:

1. Open a command window.
2. Configure the operating system environment variables.
3. Start SQL*plus using a command

sqlplus {username | /} [as sysdba]

Example, 

$ sqlplus '/ AS SYSDBA'
Enter password: password

About SQL Developer:

SQL Developer provides another GUI for accessing your Oracle database.
It is available in the default installation of Oracle Database.

With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, also create and save your own.

You can download SQL Developer from the Oracle Technology Network (OTN) Web site.

Link: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html