Note: The separator in the string is the underscore "_"
I want to create two new columns in the view, one called filename and one called DateLastUploaded.
Using the "_" (underscore) as the separator, I want to extract the filename to one column and the date and time to another. Using the above as a quick example, we would end up with two columns looking like this:
Attached to this question is some sample data. If you create a table from the sample data called HEALTHCHECK, the column containing the existing string is called LAST_DATA_FILENAME.
Having created the two new columns, I need to use their values in the HAVING clause e.g.
Select ..... (logic to select all existing columns and create two new columns called FILENAME AND LASTUPLOADDATE)
GROUP BY ..... To remove duplicates ....
HAVING MAX (HEALTHCHECK.DATELASTUPLOADED) < SYSDATE - 0.5
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.
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…