![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
村西那条弯弯的河流
这个作者很懒,什么都没留下…
展开
-
oracle创建表空间导入dmp表
--收回dba权限revoke dba from nfam2;drop user nfam2 cascade;drop tablespace NFAM2 including contents and datafiles cascade constraint;drop tablespace NFAM_TEMP2 including contents and datafiles cascade constraint;--创建临时表空间2.0create temporary tablespace.原创 2020-06-30 13:24:49 · 307 阅读 · 0 评论 -
mysql、oracel中当满足某些条件时强制转换赋值和保持原值用法
该用法和java的if else if else用法类似,如果能在sql中写这种判断比在java代码中写会更简洁美观。1、mysql方式: SELECT NAME,(CASE DEGREE WHEN 70 THEN '7' WHEN 80 THEN '8' WHEN 90 THEN 9 END) AS DEGREE FROM COURSE (1)当degree值为70时,...原创 2019-07-29 23:54:02 · 1084 阅读 · 0 评论