如果a為空,Nvl(a,0)返回0,否則返回a。
nvl( null,0) = 0
nvl( 1,0) = 1
nvl( 2,0) = 2
nvl( 3,0) = 3
nvl( 4,0) = 4
decode(nvl(a,0),1,2,3)
如果nvl(a,0) = 1,則返回2,否則返回3。
decode(nvl( null,0),1,2,3) = 3
decode(nvl( 1,0),1,2,3) = 2
decode(nvl( 2,0),1,2,3) = 3
decode(nvl( 3,0),1,2,3) = 3
decode(nvl( 4,0),1,2,3) = 3