Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

add color to sql column data

842894Apr 19 2011 — edited Apr 25 2011
Please help to provide blue color and underline for the column data.
i wanted to add in sql only.
How can i add it
select 
decode(TUFF_GENERIC_PKG.adj_status_func(m.billing_key),'Y','<a href="javascript:alert(''This billing period has an open adjustment request currently pending'')">'||  to_char(to_date('01/'||trim(substr(M.REPORT_PERIOD,5,2))||'/'||
trim(substr(M.REPORT_PERIOD,1,4)),'DD/MM/YYYY'),'Month YYYY') ||'</a>','<a href="f?p=&APP_ID.:5:&APP_SESSION.:BRANCH:NO:
5:P5_BILLING_KEY:'||m.billing_key||'">'||  to_char(to_date('01/'||trim(substr(M.REPORT_PERIOD,5,2))||'/'||
trim(substr(M.REPORT_PERIOD,1,4)),'DD/MM/YYYY'),'Month YYYY') ||'</a>')
from dual;
This post has been answered by jariola on Apr 19 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2011
Added on Apr 19 2011
19 comments
12,218 views