Oracle数据库安装创建表空间创建用户连接实现主键自增

浅浅的花香味﹌ 2023-03-01 12:58 34阅读 0赞

### 1.下载安装包 ###

(或者官网下载) 链接：https://pan.baidu.com/s/1t5pQoHnujrFZUjDv6W2g9w   
提取码：duje

### 2.安装 ###

![20200726153228562.png][]

![20200726153254852.png][]

![20200726153315879.png][]

![20200726153333351.png][]

![20200726153347587.png][]

![20200726153401857.png][]

![20200726153415114.png][]

![20200726153426737.png][]

![20200726153439497.png][]

![20200726153450838.png][]

![20200726153502204.png][]

![2020072615351354.png][]

![20200726153531419.png][]

![20200726153548251.png][]

![20200726153559292.png][]

![20200726153613415.png][]

![20200726153625223.png][]

### 3.连接Oracel数据库 ###

用户名 SYSTEM   密码自己设置的

### 4.建立表空间 ###

![20200726153757300.png][]

![20200726153818560.png][]

![20200726154111581.png][]

![20200726154157643.png][]

### 5.创建用户 ###

![20200726154236589.png][]

![20200726154258439.png][]

![2020072615463736.png][]

![20200726154703924.png][]

![20200726154735399.png][]

![20200726154801773.png][]

![20200726154848750.png][]

保存用户

### 6.连接新建用户 ###

用户名 刚自定义用户名

密码 刚设置的密码

![2020072615505315.png][]

![20200726155147609.png][]

到此 表空间和用户都创建好了,剩下的就是创建表了

create table NOREVENUE_MSG(
    ID number(11) primary key, 
    PAYER_NAME VARCHAR(510)  NULL,
    PAYER_NUM VARCHAR(510)  NULL, 
    PAYER_BANK VARCHAR(510)  NULL, 
    UNIT VARCHAR(510)  NULL, 
    NUMB VARCHAR(510)  NULL, 
    PAY_STAND VARCHAR(510)  NULL, 
    MONEY VARCHAR(510)  NULL,
    UPDATE_DATE DATE DEFAULT SYSDATE   /*设置时间自动插入*/
    );
    /*创建自增函数*/
    create sequence NOREVENUE_MSG_ID  
           increment by 1 
           start with 1   
           nomaxvalue     
           nocycle         
           nocache;   
    /*设置触发器,每次插入获取前一个id的值,自增*/
    CREATE TRIGGER NOREVENUE_MSG_trigger
       BEFORE INSERT ON NOREVENUE_MSG
       FOR EACH ROW
       WHEN (new.ID is null)
    begin
       select NOREVENUE_MSG_ID.nextval into :new.ID from sys.dual;
    end;

参考资料 : [https://blog.csdn.net/qq\_27732693/article/details/52254101][https_blog.csdn.net_qq_27732693_article_details_52254101]                          [https://jingyan.baidu.com/article/363872eccfb9266e4aa16f5d.html][https_jingyan.baidu.com_article_363872eccfb9266e4aa16f5d.html]

[20200726153228562.png]: /images/20230208/b68d0a78b9f64fe1a1a5c7a911a38724.png
[20200726153254852.png]: https://img-blog.csdnimg.cn/20200726153254852.png
[20200726153315879.png]: https://img-blog.csdnimg.cn/20200726153315879.png
[20200726153333351.png]: https://img-blog.csdnimg.cn/20200726153333351.png
[20200726153347587.png]: https://img-blog.csdnimg.cn/20200726153347587.png
[20200726153401857.png]: https://img-blog.csdnimg.cn/20200726153401857.png
[20200726153415114.png]: https://img-blog.csdnimg.cn/20200726153415114.png
[20200726153426737.png]: https://img-blog.csdnimg.cn/20200726153426737.png
[20200726153439497.png]: https://img-blog.csdnimg.cn/20200726153439497.png
[20200726153450838.png]: https://img-blog.csdnimg.cn/20200726153450838.png
[20200726153502204.png]: https://img-blog.csdnimg.cn/20200726153502204.png
[2020072615351354.png]: https://img-blog.csdnimg.cn/2020072615351354.png
[20200726153531419.png]: https://img-blog.csdnimg.cn/20200726153531419.png
[20200726153548251.png]: https://img-blog.csdnimg.cn/20200726153548251.png
[20200726153559292.png]: https://img-blog.csdnimg.cn/20200726153559292.png
[20200726153613415.png]: https://img-blog.csdnimg.cn/20200726153613415.png
[20200726153625223.png]: https://img-blog.csdnimg.cn/20200726153625223.png
[20200726153757300.png]: https://img-blog.csdnimg.cn/20200726153757300.png
[20200726153818560.png]: https://img-blog.csdnimg.cn/20200726153818560.png
[20200726154111581.png]: https://img-blog.csdnimg.cn/20200726154111581.png
[20200726154157643.png]: https://img-blog.csdnimg.cn/20200726154157643.png
[20200726154236589.png]: https://img-blog.csdnimg.cn/20200726154236589.png
[20200726154258439.png]: https://img-blog.csdnimg.cn/20200726154258439.png
[2020072615463736.png]: https://img-blog.csdnimg.cn/2020072615463736.png
[20200726154703924.png]: https://img-blog.csdnimg.cn/20200726154703924.png
[20200726154735399.png]: https://img-blog.csdnimg.cn/20200726154735399.png
[20200726154801773.png]: https://img-blog.csdnimg.cn/20200726154801773.png
[20200726154848750.png]: https://img-blog.csdnimg.cn/20200726154848750.png
[2020072615505315.png]: https://img-blog.csdnimg.cn/2020072615505315.png
[20200726155147609.png]: https://img-blog.csdnimg.cn/20200726155147609.png
[https_blog.csdn.net_qq_27732693_article_details_52254101]: https://blog.csdn.net/qq_27732693/article/details/52254101
[https_jingyan.baidu.com_article_363872eccfb9266e4aa16f5d.html]: https://jingyan.baidu.com/article/363872eccfb9266e4aa16f5d.html