Hi,
I am faced to a particular problem. I run a DB 24/24/ storing data from measurement equipements. It seems that data has not been received or stored from 4th March until 20th March.
In order to see if any table received data, i would like to search all the schema "SIVOA" for a column type Date and named DATE1 if it contains any rows are beetween these two dates. All the tables have the same structure for example :
CREATE TABLE "SIVOA"."EVV_DB01"
( "CLEF_VAR" NUMBER(4,0),
"DATE1" DATE,
"VALEUR" NUMBER(16,8)
)
Values :
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 00:00','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 00:15','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 00:30','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 00:45','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 01:00','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 01:15','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 01:30','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 01:45','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 02:00','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 02:15','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 02:30','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 02:45','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('4695',to_date('03/03/15 02:58','DD/MM/YY HH24:MI'),'52,1599998');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('4695',to_date('03/03/15 02:58','DD/MM/YY HH24:MI'),'52,1699982');
Insert into EVV_DB01 (CLEF_VAR,DATE1,VALEUR) values ('5002',to_date('03/03/15 03:00','DD/MM/YY HH24:MI'),'52,1699982');
For example I would like to search across all the tables of the schema SIVOA for date values in column DATE1 between '03/03/15 00:00' and '03/03/15 02:30' (DD/MM/YYYY HH24:MI)
Thank you.