Steps for installing and configuring Oracle

The following articles mainly introduce the SQL * Plus operations after Oracle installation and configuration, including the description of the system environment and related code, if you are interested in the actual operations, you can click to view the following articles.

System Environment:

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. 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 introduction to the SQL * Plus operation after Oracle is installed and configured. I hope you will gain some benefits.

Article by: http://www.programbbs.com/doc/class10-3.htm