Basic Oracle Data Operations

1. What is Oracle

Before learning the DRP system, I have mentioned Oracle many times and learned about it. What is Oracle? Today, I finally unveil its secrets.

Oracle: A company. Of course, I am talking about Oracle databases here. Like SQL server, it is a relational database management system. Because Oracle processes large data quickly, it is called an enterprise-level database, while SQL Server is a small and medium-sized database.

Ii. Basic operations

After learning about Oracle, familiarize yourself with the Oracle database from basic operations.

1. Oracle Database Installation

I don't need to introduce this. There are many such tutorials on the network, all of which are detailed.

2. Connect to the database

To connect to a database, you just want to operate the database. Here are two methods:

Command Line Operation: Enter sqlplus at the command line and press Enter.

Connect to a database using PLSQL

(1) enter the system as a system role

(2) create a new commandwindow

3. Create a user

Both methods have the same statement: createuserusername identified bypassword;

They are:

 

3. Create and modify the tablespace, and then run the SQL statement.

Command Line Effect

Plsql results

These are all simple operations, and the statements are similar to those learned before. However, some problems encountered when connecting oracle with plsql will be introduced later.