ORACLE實訓心得體會.doc

oracle 1132304112 20121221oracleoracleoracle select t_sqloracle oracle20121221oracleoracleoracleoracleoracleoracleoracleoracleoracleoracleoracle * 113230* *1 * b10-509oracle1. oracle 11g(1)oracle 11g (2)oracle 11g(3)oracle 11g (4)oracle 11g(5)pl/sqloracle 11g (6)oracle 11g (7)oracle 11g (8)oracle 11g (9)oracle 11g2. oracle 11gsql(1) (2) (3)(4)studentmisoracle 11g33 : () 1.student3. student - = - 1. studentinfo - =create table scott.studentinfo (s_id char(15) primary key not null,- - - s_name varchar2(30) unique not null,s_cardid varchar2(18) not null, s_address char(30) not null,s_gender char(2) not null check(s_gender=or s_gender=),- c_id char(10) not null references scott.classinfo(c_id), - - - - - s_xj varchar2(10) not null, s_birth date not null, s_mz varchar2(6) not null );insert into scott.studentinfo values(1132304131,*2011031001,to_date(1989-08-20,yyyy-mm- dd),01);insert into scott.studentinfo values(1132304134,*2011031001,to_date(1991-10-20,yyyy-mm- dd),01);insert into scott.studentinfo values(1132304124,*2011031001,to_date(1992-08-20,yyyy-mm- dd),01);insert into scott.studentinfo values(2005031001012005031001,to_date(1982-05-18,yyyy-mm- dd),01);insert into scott.studentinfo values(2005031001042005031001,to_date(1994-05-18,yyyy-mm- dd),01);- = - 2. classinfo- =create table scott.classinfo (c_id char(10) primary key not null, );insert into scott.classinfo values(2005031001,051,03,0310); insert into scott.classinfo values(2010031001,101,03,0310);- - - c_name varchar2(30) unique not null,b_id char(2) not null references scott.bumeninfo(b_id), - z_id char(5) not null references scott.zhuanyeinfo(z_id)- = - 3. bumeninfo - =create table scott.bumeninfo (b_id char(2) primary key not null,- - b_name varchar2(30) unique not null,b_tel char(9) not nullb_fzr char(10) not null, - - );insert into scott.bumeninfo values(03,2783857);- = - 4. zhuanyeinfo - =create table scott.zhuanyeinfo (z_id char(5) primary key not null,- - z_name varchar2(30) unique not null,z_tel char(9) not null,z_fzr char(10) not null, - - - z_xz char(10) not null, - b_id char(2) not null references scott.bumeninfo(b_id), z_ksnf char(5) not null );insert into scott.zhuanyeinfo values(0310,8208290,3,03,2003); insert into scott.zhuanyeinfo values(0311,*,8208291,3,03,2004);- - = - 5. courseinfo - =create table scott.kechenginfo (k_id char(10) primary key not null,- - - k_name varchar2(30) unique not null,z_id char(5) not null references scott.zhuanyeinfo(z_id),k_xf char(10) not null, - k_zks char(10) not null,- - k_kclx char(10) not null, - k_skxs char(10) not null );- = - 6. xchengjiinfo - =create table scott.xchengjiinfo (s_id char(15) not null references scott.studentinfo(s_id),- oracle1. 2. cmdipconfig ping ping ping ip ping ip 3. . c/s/4. adadadad3ad5. ipipipip 6. dhcpdhcpdhcp ipdhcpdhcp ip7. ftp20.2021ftp212ftp oracleoracleoraclesqlxml1oracle2oraclesyssystem,sql*plusconnect sys/123456 as sysdba; 123456connect zhangsan/123456;3grant selectselectselectiveinfo1,selectiveinfo1selectteacher4