SQL*Plus Tutorial

Connect to SQL * Plus

After you connect with SQL * Plus on oracle database you can give:
- SQL commands
- run PL/SQL blocks
- SQL * Plus commands



Connect to another database

Connect to another database with SQL * Plus:
CONNECT [username [/password]] [@ database_name]



Link between two database

Creating a link between local database and a remotely database:

CREATE [PUBLIC] DATABASE LINK link_name
CONNECT TO username
IDENTIFIED BY password
USING remotely_database

If you want to drop a link between two databases, one local and one remote:

DROP [PUBLIC] DATABASE LINK link_name.

To close the SQL * Plus session you can use QUIT or EXIT commands.