Oracle 數據庫，oracle數據庫等級,[數據庫]Oracle數據庫建表并用SQL編程分等級

[數據庫]Oracle數據庫建表并用SQL編程分等級

0

2016-06-15 23:00:13

Oracle 數據庫？--創建學生表

create table XS_543

( XH char(6) not null ,

XM varchar2(20) not null,

oracle怎么創建新的數據庫，ZYM varchar2(10),

XB char(4) default '男',

CSSJ date,

ZXF number(2),

sql數據庫怎么創建表、BZ varchar2(100),

constraint pk_xh primary key(xh)

);

--創建課程表

oracle sql developer，create table KC_543

(

KCH char(3) not null ,

KCM varchar2(20) not null ,

oracle數據庫有什么用、KKXQ number(1) default 1 ,

XS number(2),

XF number(1),

constraint pk_kch primary key (kch),

oracle數據庫創建系列，constraint ck_kkxq check(KKXQ between 1 and 8)

);

--創建成績表

create table XS_KC_543

sql oracle？(

XH char(6) not null ,

KCH char(3) not null ,

CJ number(3),

oracle 數據庫如何創建任務、constraint pk_xh_kch primary key (XH,KCH),

constraint fk_xh foreign key (xh) references xs_543(xh),

constraint fk_kch foreign key (kch) references kc_543(kch)

);

oracle數據庫建表建在哪里？--插入數據

insert into XS_543 values('061101','王林', '計算機','男',to_date('1986-2-01','yyyy-mm-dd'),50,null);

insert into XS_543 values('061102','程明', '計算機','男',to_date('1987-2-10','yyyy-mm-dd'),50,null);

insert into XS_543 values('061103','王燕', '計算機','女',to_date('1985-1-06','yyyy-mm-dd'),50,null);

insert into XS_543 values('061104','韋10嚴平','計算機','男',to_date('1986-8-26','yyyy-mm-dd'),50,null);

insert into XS_543 values('061106','李方方','計算機','男',to_date('1986-11-20','yyyy-mm-dd'),50,null);

insert into XS_543 values('061107','李明', '計算機','男',to_date('1986-5-01','yyyy-mm-dd'),54,'提前修完數據結構');

insert into XS_543 values('061108','林一帆','計算機','男',to_date('1985-8-05','yyyy-mm-dd'),50,'已提前修完一門課');

insert into XS_543 values('061109','張強民','計算機','男',to_date('1984-8-11','yyyy-mm-dd'),50,null);

insert into XS_543 values('061110','張蔚', '計算機','女',to_date('1987-7-22','yyyy-mm-dd'),50,'三好學生');

insert into XS_543 values('061111','趙琳', '計算機','女',to_date('1986-3-18','yyyy-mm-dd'),50,null);

insert into XS_543 values('061113','嚴紅', '計算機','女',to_date('1985-8-11','yyyy-mm-dd'),48,'一門課不及格');

insert into XS_543 values('061201','王敏', '通信工程', '男',to_date('1984-6-10','yyyy-mm-dd'),42,null);

insert into XS_543 values('061202','王林', '通信工程', '男',to_date('1985-1-29','yyyy-mm-dd'),42,null);

insert into XS_543 values('061203','王玉民','通信工程','男',to_date('1986-3-26','yyyy-mm-dd'),42,null);

insert into XS_543 values('061204','馬琳琳','通信工程','女',to_date('1984-2-10','yyyy-mm-dd'),42,null);

insert into XS_543 values('061206','李計', '通信工程','女',to_date('1985-9-20','yyyy-mm-dd'),42,null);

insert into XS_543 values('061210','李紅慶','通信工程','女',to_date('1985-5-10','yyyy-mm-dd'),44,'提前修完一門課');

insert into XS_543 values('061216','孫祥欣', '通信工程','女',to_date('1984-3-09','yyyy-mm-dd'),42,null);

insert into XS_543 values('061218','孫研', '通信工程','男',to_date('1986-10-9','yyyy-mm-dd'),42,null);

insert into KC_543 values('101','計算機基礎',1,80,5);

insert into KC_543 values('102','程序設計語言',2,68,4);

insert into KC_543 values('206','離散數學',2,68,4);

insert into KC_543 values('208','數據結構',5,68,4);

insert into KC_543 values('209','操作系統',6,68,4);

insert into KC_543 values('210','計算機原理',7,85,5);

insert into KC_543 values('212','數據庫原理',7,68,4);

insert into KC_543 values('301','計算機網絡',7,51,3);

insert into KC_543 values('302','軟件工程',7,51,3);

insert into XS_KC_543 values('061101','101',80);

insert into XS_KC_543 values('061101','102',78);

insert into XS_KC_543 values('061101','206',76);

insert into XS_KC_543 values('061103','101',62);

insert into XS_KC_543 values('061103','206',81);

insert into XS_KC_543 values('061103','102',70);

insert into XS_KC_543 values('061104','101',90);

insert into XS_KC_543 values('061104','102',84);

insert into XS_KC_543 values('061104','206',65);

insert into XS_KC_543 values('061102','102',78);

insert into XS_KC_543 values('061102','206',78);

insert into XS_KC_543 values('061107','101',78);

insert into XS_KC_543 values('061107','102',80);

insert into XS_KC_543 values('061107','206',68);

insert into XS_KC_543 values('061108','101',85);

insert into XS_KC_543 values('061108','102',64);

insert into XS_KC_543 values('061108','206',87);

insert into XS_KC_543 values('061109','101',66);

insert into XS_KC_543 values('061109','102',83);

insert into XS_KC_543 values('061109','206',70);

insert into XS_KC_543 values('061111','206',76);

insert into XS_KC_543 values('061113','101',63);

insert into XS_KC_543 values('061113','102',79);

insert into XS_KC_543 values('061113','206',60);

insert into XS_KC_543 values('061201','101',80);

insert into XS_KC_543 values('061202','101',65);

insert into XS_KC_543 values('061203','101',87);

insert into XS_KC_543 values('061204','101',91);

insert into XS_KC_543 values('061210','101',76);

commit;

declare

v_xh xs_kc_543.xh%type;

v_kch xs_kc_543.kch%type;

v_cj xs_kc_543.cj%type;

rank char(2);

begin

v_xh:=&v_xh;

v_kch:=&v_kch;

select cj into v_cj from xs_kc_543 where xh=v_xh and kch=v_kch;

case v_cj/10

--上次這個地方出錯了

when 9 then rank:='a';

when 8 then rank:='b';

when 7 then rank:='c';

when 6 then rank:='d';

when 5 then rank:='e';

end case;

dbms_output.put_line(rank);

end;

轉載請保留本文網址：http://www.shaoqun.com/a/232351.html

*特別聲明：以上內容來自于網絡收集，著作權屬原作者所有，如有侵權，請聯系我們：admin@shaoqun.com。

sql

0