CONNECT
statement. Instead your system looks for database login credentials in the client wallet.SERVICE_NAME
is the global database name entered during database creation. It combines a database name with a domain name. For example, the SERVICE_NAME
sales.us.acme.com
has a database name of sales
and a domain of us.acme.com
.INSTANCE_NAME
is the name you give to the database instance during creation. It defaults to the SID you entered during database creation.SID
) identifies a specific Oracle release 8.0 database instance.INSTANCE_NAME
in place of the SERVICE_NAME
phrase.SID
in place of the SERVICE_NAME
when connecting to an Oracle release 8.0 or earlier database.SQLPLUS -M 'HTML ON PREFORMAT ON'
SET MARKUP HTML ON PREFORMAT ON
Command | Level 1 | Level 2 | Level 3 |
---|---|---|---|
EDIT | disabled | disabled | disabled |
GET | disabled | ||
HOST | disabled | disabled | disabled |
SAVE | disabled | disabled | |
SPOOL | disabled | disabled | |
START, @, @@ | disabled | ||
STORE | disabled | disabled |