How can i modify the below to search for the things i'm looking for during a certain time frame?
Code:
select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc;
In this particular case, this query is suppose to pull out all the Alerts received on December 5th, 2010. But, that could be a lot of alerts. So i only want to pull out alerts received on that date but between between the time of 2:00pm and 8:00pm.
it's the table that contains the information I want to grab out. im not sure I know how to describe it well enough. i just want to be able to pull things out of the table by time and date.
i think something like the below may need to be incorporated in my db statement. i'm not sure:
it's the table that contains the information I want to grab out. im not sure I know how to describe it well enough....
"DESCRIBE" is a command of Oracle's own client - SQL*Plus. When run, it displays the structure of a table i.e. column names, their datatypes, sizes, whether they are nullable or not etc.
I believe fpmurphy wanted you to use that command, rather than plain English, to describe your table.
In any case, you may want to try this Oracle query -
Code:
---- This query fetches all records that have LASTOCCURRENCE values between-- 5-Dec-2010 2:00 PM and 5-Dec-2010 8:00 PM, **both timestamps inclusive**--SELECT node, nodealias, summary, tally, alertkey, alertgroup, manager, agent FROM mrtg_alerts WHERE lastoccurrence BETWEEN TO_DATE ('5-DEC-2010 14:0:0', 'DD-MON-YYYY HH24:MI:SS') AND TO_DATE ('5-DEC-2010 20:0:0', 'DD-MON-YYYY HH24:MI:SS')ORDER BY manager DESC;
Note that "between" over here means:
- the timestamp 5-Dec-2010 2:00 PM, and
- all timestamps between 2:00 PM and 8 PM on 5-Dec-2010, and
- the timestamp 5-Dec-2010 8:00 PM
Here's an equivalent query that uses the numeric relational operators instead of BETWEEN -
Code:
-- Equivalent querySELECT node, nodealias, summary, tally, alertkey, alertgroup, manager, agent FROM mrtg_alerts WHERE lastoccurrence >= TO_DATE ('5-DEC-2010 14:0:0', 'DD-MON-YYYY HH24:MI:SS') AND lastoccurrence <= TO_DATE ('5-DEC-2010 20:0:0', 'DD-MON-YYYY HH24:MI:SS')ORDER BY manager DESC;
Good evening
I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus.
I tried to find out the user/passwd and service name by env variable and all Ive got is this:
ORACLE_SID_REPCOL=SCL_REPCOL
ORACLE_SID=xmeta
ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error:
ERROR: ORA-01017: invalid username/password; logon denied... (2 Replies)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options.
OPERATION_TYPE = "createDatabase"
GDBNAME = "solaris_user.domain.com"
SID = "solaris_user"
TEMPLATENAME = "General... (0 Replies)
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
