山东大学数据库实验3代码.docx
需积分: 12 127 浏览量
2021-04-24
15:23:53
上传
评论 1
收藏 313KB DOCX 举报
create table test3_01(
sid char(12),
name varchar(10),
age number (22),
birthday date,
dname varchar(30),
class varchar(10)
);
Insert into test3_01
Select *
From pub.student_31;
3-1
create table test3_01 as
select * from pub.student_31
where (
substr(sid,0,1) in('0','1','2','3','4','5','6','7','8','9')and
substr(sid,1,1) in('0','1','2','3','4','5','6','7','8','9')and
substr(sid,2,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,3,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,4,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,5,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,6,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,7,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,8,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,9,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,10,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,11,1) in('0','1','2','3','4','5','6','7','8','9') and
substr(sid,12,1) in('0','1','2','3','4','5','6','7','8','9'));
3-2
create table test3_02 as
select * from pub.student_31
where ( extract(year from birthday)=2012-age);
3-3
create table test3_03 as
select * from pub.student_31
where (sex in ('女','男') or (sex is null));
3-4
资源评论
