Oracle 8i 中的union all不支持null
来源:互联网 发布:oracle12c容器数据库 编辑:程序博客网 时间:2024/05/29 13:29
Oracle 9i 在8i的基础上对,union all 函数的改进.
以下是9i 数据库
SQL> select version from v$instance;
VERSION
-----------------
9.2.0.4.0
SQL> select 1 from dual
2 union all
3 select 2 from dual;
1
----------
1
2
SQL> select 1 from dual
2 union all
3 select null from dual;
1
----------
1
SQL> select sysdate from dual
2 union all
3 select null from dual;
SYSDATE
---------
19-DEC-06
以下是8i数据库.
SQL> select version from v$instance;
VERSION
-----------------
8.1.6.3.0
SQL> select 1 from dual
2 union all
3 select 2 from dual;
1
----------
1
2
SQL> select 1 from dual
2 union all
3 select null from dual;
select 1 from dual
*
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression
SQL> select 1 from dual
2 union
3 select null from dual;
select 1 from dual
*
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression
SQL> select sysdate from dual
2 union all
3 select sysdate from dual;
SYSDATE
---------
19-DEC-06
19-DEC-06
SQL> select sysdate from dual
2 union all
3 select null from dual;
select sysdate from dual
*
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression
VERSION
-----------------
8.1.6.3.0
SQL> select 1 from dual
2 union all
3 select 2 from dual;
1
----------
1
2
SQL> select 1 from dual
2 union all
3 select null from dual;
select 1 from dual
*
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression
SQL> select 1 from dual
2 union
3 select null from dual;
select 1 from dual
*
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression
SQL> select sysdate from dual
2 union all
3 select sysdate from dual;
SYSDATE
---------
19-DEC-06
19-DEC-06
SQL> select sysdate from dual
2 union all
3 select null from dual;
select sysdate from dual
*
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression
- Oracle 8i 中的union all不支持null
- Oracle中的Union、Union All
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle 中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- Oracle中的Union、Union All、Intersect、Minus
- oracle中的union和union all
- 显示ip时,如何把255.255.255.255显示成255.255.*.*
- Java FTP客户端(未完整)
- 《C++ Primer》学习笔记——第四章表达式
- 给我留言讨论问题的朋友请注意了!
- “酷”是抗争,非我本性
- Oracle 8i 中的union all不支持null
- 一道简单题目的复杂算法
- Java EE 5.0 SDK Update 2 提供下载
- Apache中虚拟主机的配制
- ASP.NET中的ajax
- VC6静态编译的一个问题
- iptables详细教程
- 每日一句2006-12-22
- Java学习第一课--Welcome to Java!