I have a SQL which results , the number of tables which uses EMAIl ID field, I have more than 60 tables which uses that EMAILID field. I want to find out how many of those 60 tables have values stored in EMAILID field and how many of them are blank
select table_name, num_rows from dba_tables
where table_name in (SELECT DISTINCT A.RECNAME FROM TABLE1 A,TABLE2 B
A.TAB_NAME = B.TAB_NAME
AND (A.FIELDNAME = 'EMAILID' OR A.FIELDNAME = 'URL'))
AND NUM_ROWS > 0;
Table1 store all information related to Record & fields , what are the fields associated to each table. Table2 stores the record definition.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…