SQL Foundation of Oracle Database

Main content: User and table space; tables and constraints; Query statements.

I. Overview

Oracle Installation: Visit the website, download

Second, the User and table space

You can log in to Oracle with SQL Puls in the Start menu when you install Oracle.

1. System users

• sys, system (sys has more permissions than system,sys can only be logged on with the administrator sysdba System can log in directly )

• Sysman (for Enterprise management, also administrator-level users)
• Scott (password default password is Tiger)

When you install Oracle, the first three users ' passwords are set by yourself and are generally set to a uniform password.

2. User Login

Logon method: (case insensitive in SQL statements)

Method One:[Username/password] [@server] [as Sysdba|sysoper]
Method Two:connnect username/password @server as Sysdba|sysoper
Example: using System User Login
System/root @orcl SA sysdba
ORCL is the service name you set ( Note: If the database and server are not on the same machine, you need to enter the service name or IP address )

3. View logged in user

• Show user command

SQL Foundation of Oracle Database