Oracle Database Query Post: 302477735

Sponsored Content

Top Forums Programming Oracle Database Query Post 302477735 by SkySmart on Monday 6th of December 2010 09:39:18 AM

12-06-2010

Registered User

Oracle Database Query

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.

Any help?

SkySmart

View Public Profile for SkySmart

Find all posts by SkySmart

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

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...

2. Solaris

Can't create database after Oracle Database installation

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...

3. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

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 ...

4. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

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...

5. Shell Programming and Scripting

Korn Script to connect and query oracle database

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...

6. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

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...

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Discussion started by: balaeswari

2. Solaris

Can't create database after Oracle Database installation

Discussion started by: solaris_user

3. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Discussion started by: DevendraG

4. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

Discussion started by: vel4ever

5. Shell Programming and Scripting

Korn Script to connect and query oracle database

Discussion started by: jackmorgan2007

6. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Discussion started by: alexcol