Snippet Name: SQL*Plus connect
Description: Samples of how to connect to the database through SQL*Plus.
Also see: » SQL*Plus Configuration
» SQL*Plus SQL Prompt
» SQL*Plus Spool Command
» SQL*Plus Display commands
» SQL*Plus Describe
» SQL*Plus formatting
Comment: (none)
Language:
Highlight Mode: PLSQL
Last Modified: March 07th, 2009
|
-- If this is a stand-alone database you created
-- you will not need a password
connn / AS sysdba
CONN AS a USER CONN <logon> / <password> @ <instance>
conn joesmith/password@orabase
conn tomthumb/password@orabase
|