Oracle创建数据库

--创建数据库
CREATE TABLESPACE monitor LOGGING DATAFILE 'D:\monitor.dbf' 
SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;

create temporary tablespace monitor_temp tempfile 'D:\monitor_temp.dbf' 
size 100m autoextend on next 32m maxsize 500m extent management local; 

--创建用户--monitor
CREATE USER monitor IDENTIFIED BY monitor DEFAULT TABLESPACE monitor TEMPORARY TABLESPACE monitor_temp;


--添加权限--monitor
grant connect,resource,dba to monitor; 
grant create session to monitor; 



CREATE TABLE employees (
    id NUMBER(10) PRIMARY KEY,
    first_name VARCHAR2(50) NOT NULL,
    last_name VARCHAR2(50) NOT NULL,
    email VARCHAR2(100),
    phone_number VARCHAR2(20),
    hire_date DATE NOT NULL,
    job_id VARCHAR2(10) NOT NULL,
    salary NUMBER(8, 2),
    manager_id NUMBER(10),
    department_id NUMBER(10)
);

SELECT * FROM employees

-- 添加第一条数据
INSERT INTO employees (id, first_name, last_name, email, phone_number, hire_date, job_id, salary, manager_id, department_id)
VALUES (1, 'John', 'Doe', 'john.doe@example.com', '555-1234', TO_DATE('2022-01-01', 'YYYY-MM-DD'), 'IT_PROG', 6000, NULL, 10);

-- 添加第二条数据
INSERT INTO employees (id, first_name, last_name, email, phone_number, hire_date, job_id, salary, manager_id, department_id)
VALUES (2, 'Jane', 'Smith', 'jane.smith@example.com', '555-5678', TO_DATE('2022-02-01', 'YYYY-MM-DD'), 'HR_REP', 4500, 1, 20);

-- 添加第三条数据
INSERT INTO employees (id, first_name, last_name, email, phone_number, hire_date, job_id, salary, manager_id, department_id)
VALUES (3, 'Alice', 'Johnson', 'alice.johnson@example.com', '555-9876', TO_DATE('2022-03-01', 'YYYY-MM-DD'), 'AC_MGR', 7000, NULL, 30);