Oracle
孟and平
这个作者很懒,什么都没留下…
展开
-
oracle 修改字符集
1.输入 sqlplus /nolog 2.将数据库启动到RESTRICTED模式下做字符集更改: SQL> conn /as sysdba Connected. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL&...原创 2018-11-26 10:19:05 · 128 阅读 · 0 评论 -
oracle 自增长序列值
DROP sequence SEQ_TICKET create sequence SEQ_TICKET minvalue 1 start with 5 increment by 1 nocache; create or replace trigger SEQ_STOPCODE before insert on STOPCODE --S_Depart 是表名 for each r...原创 2018-11-26 10:20:26 · 849 阅读 · 0 评论 -
oracle 用户和修改字段
--新建表空间和用户 create tablespace IUser datafile 'IUser.dbf' size 10m; create temporary tablespace IUser_temp tempfile 'IUser_temp.dbf' size 10m; create user C##iuser identified by iuser account unlock; ...原创 2018-11-26 10:21:33 · 133 阅读 · 0 评论