当前位置：首页 > 数据库 > oracle >

Oracle case函数使用介绍

来源:网络整理作者:网络发布时间:2020-12-10 23:28

这篇文章主要通过实例简要介绍case函数的用法，学习oracle的朋友可以参考下...

current_credits NUMBER(3),

ID FIRST_NAME LAST_NAME MAJOR CURRENT_CREDITS GR
first_name VARCHAR2(20),
)

复制代码代码如下:

) a

SQL> select * from students;

else 'd' end grade

10002 Joanne Junebug Computer Science 75
CREATE SEQUENCE student_sequence START WITH 10000 INCREMENT BY 1;

where a.id = students.id

commit;
/
10002 Joanne Junebug Computer Science 75 c
---------- -------------------- -------------------- ------------------------------ --------------- --

INSERT INTO students (id, first_name, last_name, major, current_credits,grade)
DROP SEQUENCE student_sequence;
10000 Scott Smith Computer Science 98
10003 Manish Murgratroid Economics 66

复制代码代码如下:

select id,
case when current_credits > 90 then 'a'
SQL> select * from students;

INSERT INTO students (id, first_name, last_name, major, current_credits,grade)

3.更新语句

DROP TABLE students;

复制代码代码如下:

grade varchar2(2));

select grade from

4.更新后结果

VALUES (student_sequence.NEXTVAL, 'Scott', 'Smith', 'Computer Science', 98,null);

id               NUMBER(5) PRIMARY KEY,
     when current_credits > 80 then 'b'
from students
major            VARCHAR2(30),
     10001 Margaret             Mason                History                                     88
update students

2.查看相应数据

VALUES (student_sequence.NEXTVAL, 'Joanne', 'Junebug', 'Computer Science', 75,null);

set grade = (
---------- -------------------- -------------------- ------------------------------ --------------- --

VALUES (student_sequence.NEXTVAL, 'Margaret', 'Mason', 'History', 88,null);

when current_credits > 70 then 'c'

10000 Scott Smith Computer Science 98 a

INSERT INTO students (id, first_name, last_name, major, current_credits,grade)

INSERT INTO students (id, first_name, last_name, major, current_credits,grade)
10001 Margaret Mason History 88 b

last_name VARCHAR2(20),

VALUES (student_sequence.NEXTVAL, 'Manish', 'Murgratroid', 'Economics', 66,null);

(

ID FIRST_NAME LAST_NAME MAJOR CURRENT_CREDITS GR
10003 Manish Murgratroid Economics 66 d
CREATE TABLE students (

相关热词： oracle

本站内容来源于网络，如有侵权请与我们联系，我们会及时删除，我们深感抱歉！
注：本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规！

本文地址: https://www.juheyunku.com/sql/oracle/2347.shtml

上一篇：oracle中如何获得数据库的

下一篇：oracle中读写blob字段的问题

OracleRAC搭建笔记	OracleRAC的五大优势及其劣势
Oracle常用SQL查询	Oracle优化器自适应执行计划
Oracle中的数值处理相关函数介	Oracle行内链接不会引起USER_TA
Window下Oracle Database 11g 发行版	Oracle 11g 安装配置图文教程
Oracle如何实现like多个值的查询	maven添加oracle依赖失败问题的处
OracleRAC基本概念及入门	Oracle索引梳理系列（八）索引
Oracle 权限（grant revoke）	Oracle数据库安装要点总结
如何对比迁移前后的Oracle数据	体系结构 Oracle参数介绍