摘要： 一、创建数据表create table t(id integer,name varchar2(50))二、添加数据insert into t values(1,'zhao')insert into t values(2,'qian')insert into t values(3,'sun')insert into t values(4,'li')三、case用法：重新给指定字段赋值例题1:select t.Name,(case t.id--此处可以省略括号,改变id为namewhen 1 then 'zhao'wh 阅读全文