如何使用函数覆盖

机床2021年09月06日

给大家展现一下这几件神剑神甲的属性:了解了傲视遮天神剑神甲的属性后 通过实例简要介绍case函数的用法。

1.创建测试表:

DROP SEQUENCE student_sequence;CREATE SEQUENCE student_sequence START WITH 10000 INCREMENT BY 1;DROP TABLE students;CREATE TABLE students ( id NUMBER(5) PRIMARY KEY, first_name VARCHAR2(20), last_name VARCHAR2(20), major VARCHAR2(30), current_credits NUMBER(3), grade varchar2(2));INSERT INTO students (id, first_name, last_name, major, current_credits,grade) VALUES (student_XTVAL, \'Scott\', \'Smith\', \'Computer Science\', 98,null);INSERT INTO students (id, first_name, last_name, major, current_credits,grade) VALUES (student_XTVAL, \'Margaret\', \'Mason\', \'History\', 88,null);INSERT INTO students (id, first_name, last_name, major, current_credits,grade) VALUES (student_XTVAL, \'Joanne\', \'Junebug\', \'Computer Science\', 75,null);INSERT INTO students (id, first_name, last_name, major, current_credits,grade) VALUES (student_XTVAL, \'Manish\', \'Murgratroid\', \'Economics\', 66,null);commit;

2.查看相应数据

SQL select * from students; ID FIRST_NAME LAST_NAME MAJOR CURRENT_CREDITS GR---------- -------------------- -------------------- ------------------------------ --------------- -- 10000 Scott Smith Computer Science 98 10001 Margaret Mason History 88 10002 Joanne Junebug Computer Science 75 10003 Manish Murgratroid Economics 66

3.更新语句

update studentsset grade = (select grade from(select id,case when current_credits 90 then \'a\' when current_credits 80 then \'b\' when current_credits 70 then \'c\'else \'d\' end gradefrom students) awhere = )/

4.更新后结果

SQL select * from students; ID FIRST_NAME LAST_NAME MAJOR CURRENT_CREDITS GR---------- -------------------- -------------------- ------------------------------ --------------- -- 10000 Scott Smith Computer Science 98 a 10001 Margaret Mason History 88 b 10002 Joanne Junebug Computer Science 75 c 10003 Manish Murgratroid Economics 66 d

查看本文来源

米诺地尔酊和米诺地尔搽剂哪个剂型好
乌鲁木齐治疗宫颈糜烂哪家好
嘉兴治疗白癜风
相关阅读
BJ40城玩系列国潮皮肤发布,“天一”绽放花城魅力

当年,杭州骑行BJ40所发布的“山海”前传3款国潮脸部,让广大故常惊艳连连...

2024-12-27
冰城限招120人,政府扶持,不限专业,在岗工作也可正常跟进,6月15日报名累计!

2022年为缓解社会福利压力,人口老龄化专升本录取人数,建立人才人工湖,...

2024-11-03
教育部:切实做好全国返校离校返乡疫情防控工作

中华民国行政院:切实做好全国性高等院校许多学生回校返台非典应付实习 ...

2024-10-27
马斯克拜师了张小龙吗?

踌躇满志入股Twitter的雷诺,突然要向张小龙“取经”了。 5同年16日,雷诺参...

2024-09-29
iPhone上的这个间谍触控板可以使打字更容易

iPhone和iPad都装载了很酷的隐秘机能,除此以外来自除此以外 iOS 15.5 越来越新...

2024-09-08
关乎大资金动向!科创板“芯片”指数来了,42只样本股名单公布;上交所几大指数也调整,腾讯、美团等权重

A股、公司股票多个极其重要指标公布或修正,这意味着之外的大资金样式也...

2024-07-30
友情链接