SQL> select add_months(trunc(to_date('31-jan-17'),'MM'),-1) from dual;
ADD_MONTH
---------
01-DEC-16
function R_G_ITEMCODEFormatTrigger return boolean is
begin
-- Automatically Generated from Report Builder.
if (MOD(:CF_1,2) = 0)
then
srw.set_foreground_fill_color('gray20');
srw.set_fill_pattern('solid');
end if;
return (TRUE);
end;
/////
function F_TEL2FormatTrigger return boolean is
begin
-- Automatically Generated from Report Builder.
if (:CF_Remain_dt <= 100)
then
srw.set_text_color('red');
end if;
return (TRUE);
end;
////
function R_G_GUARNOFormatTrigger return boolean is
begin
if (:CF_remain_dt <=30)
then
srw.set_foreground_fill_color('gray20');
srw.set_fill_pattern('solid');
end if;
return (TRUE);
end;
--• Business Solutions: --• Enterprise ERP, Database Management & IT Infrastructure --• AI, Cloud
Subscribe to:
Post Comments (Atom)
https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
I wanted to share a little trick I’ve used in APEX for a while now to conditionally format report columns based on their values. I’m sure th...
No comments:
Post a Comment