test the difference between "DEFAULT NULL" and "DEFAULT 0"
来源:互联网 发布:1848年革命 知乎 编辑:程序博客网 时间:2024/04/30 05:03
/*
intent: test the difference between "DEFAULT NULL" and "DEFAULT 0"
anthor: t0nsha(liaodunxia{at}gmail.com@20081219)
*/
DECLARE
ln_dft_null NUMBER DEFAULT NULL;
ln_dft_zero NUMBER DEFAULT 0;
BEGIN
ln_dft_null := ln_dft_null + 1;
dbms_output.put_line('ln_dft_null = ' || ln_dft_null);
ln_dft_zero := ln_dft_zero + 1;
dbms_output.put_line('ln_dft_zero = ' || ln_dft_zero);
END;
/*dbms_output:
ln_dft_null =
ln_dft_zero = 1
*/
intent: test the difference between "DEFAULT NULL" and "DEFAULT 0"
anthor: t0nsha(liaodunxia{at}gmail.com@20081219)
*/
DECLARE
ln_dft_null NUMBER DEFAULT NULL;
ln_dft_zero NUMBER DEFAULT 0;
BEGIN
ln_dft_null := ln_dft_null + 1;
dbms_output.put_line('ln_dft_null = ' || ln_dft_null);
ln_dft_zero := ln_dft_zero + 1;
dbms_output.put_line('ln_dft_zero = ' || ln_dft_zero);
END;
/*dbms_output:
ln_dft_null =
ln_dft_zero = 1
*/
- test the difference between "DEFAULT NULL" and "DEFAULT 0"
- In Java, what's the difference between public, default, protected, and private?
- What is the difference between test, [ and [[ ?
- The difference between (()) and ().
- The difference between null and isEmpty in Groovy
- what's the difference between NULL 0 '\0' and ""/''(space string or char) ?
- Difference between new Test() and new Test() { }
- the difference between "./" and "sh"
- the difference between the SOURCELIBS and TARGETLIBS
- What is the difference between 0 dB and 0 dBFS
- whats is the difference between train, validation and test set, in neural networks?
- Whats is the difference between train, validation and test set, in neural networks?
- The difference between Const and ReadOnly
- The difference between Failure and Success
- The difference between Process and Procedure
- The difference between GetDC and GetWindowDC
- The difference between Chinese and American
- The difference between J2ee and Ruby
- 特殊字符编码
- As3.0 一些好书连接
- JS替换字符串
- AOP 详细描述
- 发一个多线程通过 HTTP 下载文件的类(Linux下的实现)
- test the difference between "DEFAULT NULL" and "DEFAULT 0"
- 遗传算法导论
- J2ME:模拟短信发送界面
- 2008年度一个下岗程序员的真实经历
- SqlHelper 类实现详细信息
- 桌面程序调用Web Service应用实例
- 打通NTFS权限 文件共享各取所需
- 为了你,我的儿子
- 光驱回来了