- 博客(2)
- 收藏
- 关注
RSS订阅原创 sqlplus 无法登录数据库
6.9版本上安装好11g的Oracle数据库后，无法使用sqlplus 登录数据库安装前遇到过[root@gugu soft]# rpm -ivh rlwrap-0.41-1.el5.i386.rpmwarning: rlwrap-0.41-1.el5.i386.rpm: Header V4 DSA/SHA1 Signature, key ID 217521f6: NOKEYerror: Failed dependencies:。。。省略解决办法：强制安装，跳过依赖查找[root@gugu s
2021-02-20 14:40:09
932
原创 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
265
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人