- 博客(2)
- 收藏
- 关注
RSS订阅原创 sqlplus 无法登录数据库
6.9版本上安装好11g的Oracle数据库后，无法使用sqlplus 登录数据库 安装前遇到过 [root@gugu soft]# rpm -ivh rlwrap-0.41-1.el5.i386.rpm warning: rlwrap-0.41-1.el5.i386.rpm: Header V4 DSA/SHA1 Signature, key ID 217521f6: NOKEY error: Failed dependencies: 。。。省略 解决办法：强制安装，跳过依赖查找 [root@gugu s
2021-02-20 14:40:09
891
原创 sql常用函数
一、空值 nvl(A,B) coalesce(A,B,C,D,…) 示例： SQL> create or replace view v1_5 as 2 select null as c1 ,null as c2,1 as c3,null as c4,2 as c5,null as c6 from dual 3 union all 4 select null as c1 ,null as c2 ,null as c3,3 as c4,null as c5,2 as c6 from d
2020-10-21 15:04:09
216
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人