Oracle installation, configuration, and SQL * Plus operations

The following articles mainly introduce Oracle installation, configuration, and SQL * Plus operation steps. I saw Oracle installation, configuration, and SQL * Plus operation steps on the relevant website two days ago, I think it's good. I just want to share it with you. I hope this will help you in your future studies.

1. Operating System: Windows 2000

2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition

3. installation path: C: \ ORACLE

Note:

Some SQL statements that Beginners should know after Oracle is installed by default

1. Connection

 
 

  
  
SQL*Plus system/manager 
 
 

2. display the current connected user

 
 

  
  
SQL> show user 
 
 

3. view the users in the system

 
 

  
  
SQL> select * from all_users; 
 
 

4. Create and authorize a user

 
 

  
  
SQL> create user a identified by a; created in the SYSTEM tablespace by default)
  
  
SQL> grant connect, resource to;
 
 

5. connect to a new user

 
 

  
  
SQL> conn a/a 
 
 

6. query all objects under the current user

 
 

  
  
SQL> select * from tab; 
 
 

7. Create the first table

 
 

  
  
SQL> create table a(a number); 
 
 

8. During Oracle Installation, We need to query the table structure

 
 

  
  
SQL> desc a 
 
 

9. Insert a new record

 
 

  
  
SQL> insert into a values(1); 
 
 

10. query records

 
 

  
  
SQL> select * from a; 
 
 

11. change history

 
 

  
  
SQL> update a set a=2; 
 
 

12. delete records

 
 

  
  
SQL> delete from a; 
 
 

13. rollback

 
 

  
  
SQL> roll;  
  
  
SQL> rollback; 
 
 

14. Submit

 
 

  
  
SQL> commit; 
 
 

The above content is a preliminary description of the SQL * Plus operation after Oracle is installed and configured. I hope it will help you in this regard.