Oracle笔记 五、创建表、约束、视图、索引、序列、同义词、表空

<div id="codeSnippetWrapper"> <div style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',courier,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px" id="codeSnippet">

  userInfo (msn varchar2(20));

  userInfo (
,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">       address varchar2(50),monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">       email varchar2(25),monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">       tel number(11)
  userInfo (
 ,--主键
 ,--非空
 18,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">       email varchar2(25) ,--唯一
 dept(deptno)—外键
 id_pk  ,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">           name varchar2(20)  name_nn  ,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">           sex number(1),monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">           age number(3)  18,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">           birthday ,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">           address varchar2(50),monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">           email varchar2(25)  email_uqe ,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">           tel number(11),monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">           deptno number(2)  dept_deptno_ref  dept(deptno)
 id_pk   (id),--也可以两个以上，联合主键
 dept_deptno_ref   (deptno)  dept(deptno),monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">            emial_name_uqe  (email,name)
  userInfo (msn varchar2(20));
  userInfo (msn varchar2(25));
  userInfo (msn);
  userInfo   id_pk;
  userInfo   id_pk   (id);
  v$_dept_view

 deptno,dname  dept;
  v$_dept_view compile;
  idx_dpt_dname  dept(dname);
  idx_dept_dname_deptno  dept(dname,deptno);
   idx_emp_ename  scott.emp(ename);
  idx_emp_rev_no  scott.emp(empno) reverse;
 bitmap  idx_emp_name  scott.emp(dname);
  tab (
  ,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">        name varchar2(20)
;
  idx_name  (col) /;
  seq;
 seq.nextval  dual;
 tab (.nextval,‘music’);
  seqtab
  2 –从2开始
 3—每次加3
  seqtab
 synonym scott_emp  scott.emp;
  synonym scott_dept  scott.dept;
 *  scott_emp;
 *  scott_dept;
 tablespace HooMS

 5M
  2M maxsize 10M;
  hoo
 hoo
 tablespace  HooMS
 tablespace temp;
 tablespace myMS

 1M
;
 
 tablespace myMS
 datafile 
 1M;
  

  2M maxsize 4M;
 hooMS;
 tablespace hooMS
;
;
 tablespace hooMS online;
 tablespace hooMS;
 tablespace hooMS
                        
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!