全部博文
-
编辑 删除
oracle的case函数控制结构DECODE()函数
oracle的case函数 create sequence STUDENT_SEQUENCE; CREATE TABLE students ( id NUMBER(5) PRIMARY KEY, stu_name VARCHAR2(20), score NUMBER(10,0), grade varchar2(2)); INSERT INTO students (id, stu_name, score, grade) VALUES (student_sequence.NEXTVAL, ’Scott’, 98,null); INSERT INTO students (id, stu_name, score, grade) VALUES (student_sequence.NEXTVAL, ’Margaret’, 88,null); INSERT INTO students (id, stu_name, score, grade) VALUES (student_seque
