with t as (
select null n from dual union all
select 0 from dual union all
select 0.5 from dual union all
select 4 from dual union all
select 4.5 from dual)
select to_number(n) verbatim
,TO_CHAR(n,'fm90.9') no_trail
,TO_CHAR(n,'fm90.0') trail_zero
,RTRIM(TO_CHAR(n,'fm90.9'),'.') trail_decimal
,RTRIM(TO_CHAR(NVL(n,0),'fm90.9'),'.') and_null
from t
/
VERBATIM NO_TRAIL TRAIL_ZERO TRAIL_DECIMAL AND_NULL
---------- -------- ---------- ------------- --------
0
0 0. 0.0 0 0
0.5 0.5 0.5 0.5 0.5
4 4. 4.0 4 4
4.5 4.5 4.5 4.5 4.5 I'm curious - does anyone have formatting techniques the prefer/hate to help follow the brackets & commas?
For example, I might indent similar to JavaScript, and line up brackets/commas.
<< my_loop >>
FOR r_rec IN (
SELECT
DECODE(this_value
,'Y', 'Yes'
,'N', 'No'
,'Maybe')
FROM that_table
) LOOP
null;
END LOOP my_loop;
Scott
No comments:
Post a Comment