--關於null在oracle資料庫中是否參與計算,進行驗證,

標籤：向下轉型   驗證   參與   sys   ber   資料   art   rom   date   

--關於null在oracle資料庫中是否參與計算,進行驗證,
with td as (
select null id,1 name from dual
),
td1 as
(
select null id,2 name from dual )

select * from td, td1 where nvl(td.id,‘0.00‘) = ‘0‘

select ‘1‘||‘0.1‘ from dual
number
number -> char
select to_char(3333.00,‘999,999,009.00‘) from dual
to_char ;
to_date ;
to_number ;
3333.00
select to_char(3.00,‘fm9990999‘) from dual
jsp ####,000
partten = ‘#################0000‘
3
03
select nvl(null,0.00) from dual ;
null 不參與計算

= 來比較時, 兩邊類型不一樣,就向下轉型
select sysdate from dual where 0 = 0 ;
select sysdate from dual where ‘0‘ = ‘0‘ ;
number ---char
char --number

nvl(td1.id,0);
null bu cnayu jis
group by
select sum(id) from td;
1
select 1+null from dual
null 不參與計算

 

--關於null在oracle資料庫中是否參與計算,進行驗證,