Basic Introduction to Oracle and common SQL * PLUS commands

Basic Introduction to Oracle and common SQL * PLUS commands

Run Database Configuration Assistant as an administrator to create a Database instance. To use Oracle, you must first start the Oracle service, find the service in the task manager, and open the services and listener services related to OracleService. If there is no listener service, you must manually create a listener service.

Oracle Installation will automatically generate sys and system users

1. The sys user is a super user with the highest permissions, The sysdba role, and the create database permission. The default password of this user is manager.

2. The system user is a management operator and has a high permission. He has the sysoper role and does not have the create database permission. The default password is change_on_install.

Generally, you can use the system user to log on to database maintenance.

The Oracle management tool SQL * plus is mainly used to execute SQL statements, pl \ SQL blocks.

Right-click SQL * plus as an administrator and enter the user name and password. The host string is the name of the instance. If only one instance is started, you can leave it blank. The default one is the one started.

Right-click to run plsql as Administrator (solve not logged on problem)

Run the following command in cmd:

Sqlplus "scott/tiger"

Sqlplus "hr/hr"

Sqlplus "sys/oracle as sysdba"

Common SQL plus commands