SQL*Plus

• SQL Plus Introduction
• SQL Plus and SQL
• SQL Plus Connect
• SQL Plus Commands
• SQL Plus Substitution variables
• SQL Plus SET Commands
• SQL Plus DEFINE Command
• SQL Plus ACCEPT Command
• SQL Plus COLUMN Command
• SQL Plus BREAK Command
• SQL Plus TTITLE / BTITLE Commands
• Examples
• Describe table
• Create Pl/SQL block
• Call Pl/SQL function
• Call Pl/SQL procedure

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.