Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> empty string or null
Why does this query return null? I would expect it to return 0. It appears
trim() is returning null,
select length(trim(substr(' n',1, 3))) from dual
Received on Thu Mar 29 2007 - 09:44:36 CDT