http://forums.oracle.com
use the following tags and put your code between them
[code]
[/code]
This will show your code formated and readable like this
SELECT CASE
WHEN cnt > 20
THEN '<font color="red">' || cnt || '</font>'
WHEN cnt <= 20
THEN '<font color="green">' || cnt || '</font>'
END AS x
FROM "MYTABLE"
WHERE TO_CHAR ("MYTABLE"."DATE", 'YYYY-MM-DD') >= '2007-04-01'
AND "MYTABLE"."SERVCODE" <> 'OBS'
instead of something like this
SELECT CASE WHEN COUNT > 20 THEN '' || cnt || '' WHEN COUNT <= 20 THEN '' || cnt || '' END AS X from "MYTABLE" where TO_CHAR ("MYTABLE"."DATE",'YYYY-MM-DD') >='2007-04-01' and "MYTABLE"."SERVCODE" <>'OBS'
I created a greasemonkey script awhile back that adds some buttons for that directly into OTN posting form http://carlback.blogspot.com/2007/09/greasemonkey-otn-forums-greasy-otn.html
ReplyDeleteand IMHO Carl's GreaseMonkey script is the best thing since sliced bread!
ReplyDeleteThx to GreaseMonkey and Carl.
ReplyDeleteSaves a lot of work.