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
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.