Deutsches Application Express Forum (ApEx) -- Installation , Engine / SQL , Anwendungen
HTMLDB Engine :  Oracle Apex The fastest message board... ever.
Alles in HTMLDB, Applikationen, Berichte, SQL ... 
Re: Farbige Reportfelder
geschrieben von: EVATQ (---.bayer.de)
Datum:

select "BACKUPFAILURES"."OWNER" as "Owner",
"BACKUPFAILURES"."SERVERNAME" as "Servername",
"BACKUPFAILURES"."NAME" as "Databasename",
"BACKUPFAILURES"."DBID" as "Database ID",
"BACKUPFAILURES"."LETZTES_INC0" as "Last INC0",
"BACKUPFAILURES"."INC0DAYS" as "Days INC0",
"BACKUPFAILURES"."LETZTES_ARCH" as "Last Arch",
"BACKUPFAILURES"."ARCHDAYS" as "Days Arch",
"BACKUPFAILURES"."AELTESTES_BACKUP" as "Oldest Backup",
"BACKUPFAILURES"."OLDDAYS" as "Days Backup"
from "BACKUPFAILURES" "BACKUPFAILURES"
where
(
instr(upper("OWNER"),upper(nvl(:P1_REPORT_SEARCH,"OWNER"))) > 0 or
instr(upper("SERVERNAME"),upper(nvl(:P1_REPORT_SEARCH,"SERVERNAME"))) > 0 or
instr(upper("NAME"),upper(nvl(:P1_REPORT_SEARCH,"NAME"))) > 0 or
instr(upper("DBID"),upper(nvl(:P1_REPORT_SEARCH,"DBID"))) > 0 or
instr(upper("LETZTES_INC0"),upper(nvl(:P1_REPORT_SEARCH,"LETZTES_INC0"))) > 0 or
instr(upper("INC0DAYS"),upper(nvl(:P1_REPORT_SEARCH,"INC0DAYS"))) > 0 or
instr(upper("LETZTES_ARCH"),upper(nvl(:P1_REPORT_SEARCH,"LETZTES_ARCH"))) > 0 or
instr(upper("ARCHDAYS"),upper(nvl(:P1_REPORT_SEARCH,"ARCHDAYS"))) > 0 or
instr(upper("AELTESTES_BACKUP"),upper(nvl(:P1_REPORT_SEARCH,"AELTESTES_BACKUP"))) > 0 or
instr(upper("OLDDAYS"),upper(nvl(:P1_REPORT_SEARCH,"OLDDAYS"))) > 0
)
and
(
ARCHDAYS>=1
or
OLDDAYS>=35
or
INC0DAYS>=8
)



1 mal bearbeitet. Zuletzt am .



Thema Neugierige geschrieben von geschrieben
Farbige Reportfelder 2275 EVATQ
Re: Farbige Reportfelder 1244 cc13
Re: Farbige Reportfelder 1098 EVATQ
Re: Farbige Reportfelder 1070 cc13
Re: Farbige Reportfelder 1083 EVATQ
Re: Farbige Reportfelder 1066 cc13
Re: Farbige Reportfelder 1079 EVATQ
Re: Farbige Reportfelder 987 cc13
Re: Farbige Reportfelder 1116 EVATQ
Re: Farbige Reportfelder 1074 cc13
Re: Farbige Reportfelder 1070 EVATQ
Re: Farbige Reportfelder 1343 cc13


In diesem Forum dürfen nur registrierte Benutzer schreiben.
This forum powered by Phorum.