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.