Oracle's use

Start:

1.win+r---> cmd-----> sqlplus "/as sysdba"//Log in as sysdba (You can create users, assign permissions, etc.)

Win+r---> cmd-----> Sqlplus username/password//Login with specified username / password

Win+r---> cmd-----> Sqlplus

Follow the prompts to enter the user name password

Locate the installation directory directly and open the sqlplus terminal.

2. Create a User:

Create user username identified by password

3. Grant Permissions:

Grant Resource , connect touser;

Resource

Create Trigger

Create sequence

Create type

CREATE PROCEDURE

Create cluster

Create operator

Create Indextype

CREATE table

Connect

Create session

4. Switch Users:

Conn Username/password

5. Import test data:

because the default locale for the data file is English , the current Windows system is Chinese, the English time display is inconsistent, the import fails, and the locale needs to be modified first

Alter session set Nls_date_language=english;

Alter session set Nls_language=english;

@ e:\oracle\summit2.sql

Start E:/oracle/summit2.sql

6. View the table structure:

DESC table_name;

Oracle's use