Oracle Database Query Post: 302478575

Sponsored Content

Top Forums Programming Oracle Database Query Post 302478575 by durden_tyler on Wednesday 8th of December 2010 09:28:37 AM

12-08-2010

Registered User

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

durden_tyler

View Public Profile for durden_tyler

Find all posts by durden_tyler

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

LEARN ABOUT DEBIAN

mfontset_lookup

mfontset_lookup(3m17n)						 The m17n Library					    mfontset_lookup(3m17n)

NAME

       mfontset_lookup - Lookup a fontset.

SYNOPSIS

       MPlist * mfontset_lookup (MFontset * fontset, MSymbol script, MSymbol language, MSymbol charset)

DESCRIPTION

       Lookup a fontset. The mfontset_lookup() function lookups fontset and returns a plist that describes the contents of fontset corresponding
       to the specified script, language, and charset.

       If script is Mt, keys of the returned plist are script name symbols for which some fonts are specified and values are NULL.

       If script is a script name symbol, the returned plist is decided by language.

       o If language is Mt, keys of the plist are language name symbols for which some fonts are specified and values are NULL. A key may be Mt
	 which means some fallback fonts are specified for the script.
       o If language is a language name symbol, the plist is a FONT-GROUP for the specified script and language.  FONT-GROUP is a plist whose keys
	 are FLT (FontLayoutTable) name symbols (Mt if no FLT is associated with the font) and values are pointers to MFont.
       o If language is Mnil, the plist is fallback FONT-GROUP for the script.
       If script is Mnil, the returned plist is decided as below.
       o If charset is Mt, keys of the returned plist are charset name symbols for which some fonts are specified and values are NULL.
       o If charset is a charset name symbol, the plist is a FONT-GROUP for the charset.
       o If charset is Mnil, the plist is a fallback FONT-GROUP.
RETURN VALUE

	   It returns a plist describing the contents of a fontset. The plist should be freed by m17n_object_unref().
COPYRIGHT

       Copyright (C) 2001 Information-technology Promotion Agency (IPA)
       Copyright (C) 2001-2011 National Institute of Advanced Industrial Science and Technology (AIST)
       Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License
       <http://www.gnu.org/licenses/fdl.html>.

Version 1.6.2							    12 Jan 2011 					    mfontset_lookup(3m17n)