Sponsored Content
Full Discussion: Oracle Database Query
Top Forums Programming Oracle Database Query Post 302478575 by durden_tyler on Wednesday 8th of December 2010 09:28:37 AM
Old 12-08-2010
Quote:
Originally Posted by SkySmart
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 query
SELECT   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;

HTH,
tyler_durden
 

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... (6 Replies)
Discussion started by: balaeswari
6 Replies

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... (0 Replies)
Discussion started by: solaris_user
0 Replies

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 ... (2 Replies)
Discussion started by: DevendraG
2 Replies

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... (9 Replies)
Discussion started by: vel4ever
9 Replies

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... (2 Replies)
Discussion started by: jackmorgan2007
2 Replies

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... (2 Replies)
Discussion started by: alexcol
2 Replies
Courier::Filter::Logger::Syslog(3pm)			User Contributed Perl Documentation		      Courier::Filter::Logger::Syslog(3pm)

NAME
Courier::Filter::Logger::Syslog - Syslog logger for the Courier::Filter framework SYNOPSIS
use Courier::Filter::Logger::Syslog; my $logger = Courier::Filter::Logger::Syslog->new(); # For use in an individual filter module: my $module = Courier::Filter::Module::My->new( ... logger => $logger, ... ); # For use as a global Courier::Filter logger object: my $filter = Courier::Filter->new( ... logger => $logger, ... ); DESCRIPTION
This class is a syslog logger class for use with Courier::Filter and its filter modules. It is derived from Courier::Filter::Logger::IOHandle. Constructor The following constructor is provided: new: returns Courier::Filter::Logger::Syslog; throws Courier::Error Creates a new logger that logs messages to syslog. Instance methods The following instance methods are provided, as inherited from Courier::Filter::Logger::IOHandle: log_error($text): throws Perl exceptions Logs the error message given as $text (a string which may contain newlines). log_rejected_message($message, $reason): throws Perl exceptions Logs the Courier::Message given as $message as having been rejected due to $reason (a string which may contain newlines). SEE ALSO
Courier::Filter::Logger::IOHandle, Courier::Filter::Logger, Courier::Filter::Overview. For AVAILABILITY, SUPPORT, and LICENSE information, see Courier::Filter::Overview. AUTHOR
Julian Mehnle <julian@mehnle.net> perl v5.14.2 2011-12-27 Courier::Filter::Logger::Syslog(3pm)
All times are GMT -4. The time now is 12:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy