HDTenEightyP/NetNews huggingface dataset:
From: spsmith@acsu.buffalo.edu (Steven P. Smith)
Newsgroups: comp.databases
Subject: Anyone Using FoxPro and Espia?
Summary: Is anyone using this combination
Keywords: Foxpro graphics Espia Imaging
Date: 22 Dec 92 19:46:53 GMT
Organization: UB

We just got a copy of Espia about a week ago and were wondering if anyone was
using it.  For those of you who have never heard of it, Espia is a graphics
environment for FoxPro.  

We're using it for simple imaging (i.e. scan and display.  Nothing special.) 
It seems to perform pretty well.  

What I'm wondering is if anyone has had bad luck storing data in memo 
fields, if there are any undocumented functions or add-ins, or if anyone
can recommend a graphics card which it works well with.

Finally, does anyone have any ideas about optimizing storage.  We're 
primarily storing Black and White documents.  Can anyone recommend a format
which might provide good compression?

I would be interested in getting in touch with anyone using this software.
Please write me at V105GTPG @ UBVMS.

						Steve       
Newsgroups: comp.databases
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Subject: Re: BLOBS (was: 500'000 records)
Organization: MIND LINK! - British Columbia, Canada
Date: Fri, 1 Jan 1993 04:10:11 GMT

> Hugh LaMaster writes:
>                                    With 30K records, you are dealing
> |> with blobs outside the normal record structure; you can run greater
> |> risks.
>
> Is there a "correct" way to deal with this problem yet?  It can show
> up in surprisingly simple DBMS applications, such as where you want to
> search through a bunch of trouble calls for matches to a particular
> problem.  1-2 years ago, when I inquired to this newsgroup, there was
> no RDBMS that could handle text searches efficiently.  (Efficiently,
> that is, compared to a text processing/retrieval system.)  Is this still
> the case?

Seems to be still the case, among the mainstream database products.
You might have some luck with middle-users (as opposed to end-users)
such as those providing db's for, say, the publishing industry ---
a wonderful source of solutions to problems that I, thank goodness,
seldom see (think about how you store the articles and pictures in
a magazine; this ad must NOT be near *that* ad, etc.) And, if you
REALLY want to see the leading edge in OODB technology and really
awesome record size and relationship problems, take a peek at
where office automation systems are going (no, I'm being serious).

I agree, though, that really usable blobs would find instant use.
We started off trying to move our E-Mail/CIM system into a standard
SQL database. Turned out to be more hassle than the old system, which
created (compressed) files in a standard unix directory and stored
the filenames in the database; directories could be nested within
directories; links could be made for multiple copies; etc.

The standard database, with 1970's technology for locking, journalling
and space management isn't a very promising engine for such applications.

Pardon me: one exception: Revelation. With 1-64kb records as part of
the basic file system,and extremely flexible dictionaries, AREV
can probably handle just about anything you'd like to put on a PC
or a LAN. But that's a rather limited domain.
--
Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca
                 or uunet!van-bc!rsoft!mindlink!Mischa_Sandberg
*-*-*-*-*-*-*-*-*-*-*
Engineers think equations are an approximation of reality.
Physicists think reality is an approximation of the equations.
Mathematicians never make the connection.
Newsgroups: comp.databases
From: tleylan@pegasus.com (Tom Leylan)
Subject: Re: Clipper Uploads
Organization: Pegasus,  Honolulu
Date: Mon, 21 Dec 92 02:12:45 GMT

<in response to the question>

>>>Are these files available on any ftp site?

Simtel20 has an \msdos\clipper subdirectory.  It isn't well stocked but
that is obviously due to lack of attention by people submitting things
to it.

You will find the Nanforum Library (public domain) on it and a few other
things.

tom

Newsgroups: comp.databases
From: awb@sei.cmu.edu (Alan Brown)
Subject: ANSI IRDS ?
Organization: Software Engineering Institute
Date: Tue, 22 Dec 1992 08:51:23 EST


Has anyone developed a public domain parser for the ANSI IRDS command
language ?   A lex/yacc implementation would be best.  Information on anything
alon these lines would be useful.

Also, I would be interested to try to contact anyone who has considered ANSI
IRDS, its implementation on a database system, and its relationship to other
data management standards (e.g., CDIF, PCTE). 

Many thanks,


Alan Brown.



-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

                  Alan W. Brown
                  Software Engineering Institute
                  Carnegie Mellon University
                  Pittsburgh
                  PA 15213

                  Tel:    412-268-6194
                  Fax:    412-268-5758
                  e-mail: awb@sei.cmu.edu

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
From: rscott@vineland.pubs.stratus.com (Richard Scott)
Newsgroups: comp.databases
Subject: MS Access Optimization
Keywords: database,DBMS,performance,Microsoft,Access
Date: 30 Dec 92 15:37:05 GMT
Organization: Stratus Computer Inc, Marlboro MA
NNTP-Posting-Host: attila.pubs.stratus.com

Anyone played around with Microsoft Access enough yet to figure out how to get  
some performance out of it (or what kinds of things cause big performance  
hits)?  I've got a simple database that I had previously implemented in MS  
Excel and am attempting to port to Access.  It has 3 tables linked by  
relationships.  The smallest is about 40 records and the largest maybe 2,000  
records.  The records would be about 150 bytes at most.  All the fields used in  
queries have been indexed.

I'm running this on a 25MHz 386 with 8Mb memory (1.5Meg is RAMDisk) and a 110Mb
IDE drive, Norton Cache, DOS 5.0, Windows 3.1, and it is S-L-O-W.  Even opening  
a form based on a query of the smallest table (40 70-byte records) takes around  
20 seconds.
-----
Richard Scott
Stratus Computer, Inc.
rscott@vineland.pubs.stratus.com
Newsgroups: comp.databases
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Subject: Re: Q PLUS E Library
Organization: MIND LINK! - British Columbia, Canada
Date: Fri, 1 Jan 1993 03:57:02 GMT

Q+E (Quick and Easy) is an interface product; it lets your applications
written in common PC tools (Visual Basic, "C", MS-EXCEL and Smalltalk
are the ones I use) talk a uniform language (SQL) while operating on data
supplied by many different engines/servers (xBase, Btrieve and Paradox
on the PC; Oracle, Sybase/SqlServer, Ingres and DB2 remotely). It works,
it's rather efficient at it, and it makes life easier all 'round.
Contact Pioneer Software in Raleigh NC (919) 859-2220.

No, I don't work for them; I like to think it's the other way around.
--
Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca
                 or uunet!van-bc!rsoft!mindlink!Mischa_Sandberg
*-*-*-*-*-*-*-*-*-*-*
Engineers think equations are an approximation of reality.
Physicists think reality is an approximation of the equations.
Mathematicians never make the connection.
Newsgroups: comp.databases
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Subject: Re: INFORMATION WANTED ON DATABASE SOFTWARE USABLE ON BOTH MAC AND IBM PC
Followup-To: comp.databases
Organization: Netcom Online Communications Service
Date: Sat, 26 Dec 1992 19:38:45 GMT

The best-selling database on the Mac, FileMaker Pro, now has a version
available for Windows.  Databases can be shared across a cross-platform
network, the interface is the same, and the database is really easy to use
and set up.  I'm not trying to play salesman for Claris, but it is a really
cool database.  Demos of it should be available on America OnLine in the
Claris forum (keyword Claris), and hopefully soon here in Internetland.

I work at Claris, which may tint my perspective somewhat, but part of the
reason I choose to work at Claris is because I really do believe in their
products.

Anyway, hope this helps!

-Nick "At least I don't need a SoundBlaster to play nice music" Triantos

I may work in Claris Technical Support, but not when I'm logged in on
the Internet...
From: tchriste@ncratl.AtlantaGA.NCR.COM (Todd Christensen)
Newsgroups: comp.databases
Subject: Progress ORACLE gateway question
Keywords: progress,oracle
Date: 23 Dec 92 17:47:12 GMT
Organization: NCR Engineering and Manufacturing Atlanta -- Atlanta, GA

To connect to an Oracle database using the Progress Oracle gateway, does the
Oracle database have to be running SQL*Net?
Organization: Penn State University
Date: Wed, 30 Dec 1992 11:44:41 EST
From: Per Fjelstad <PEF2@psuvm.psu.edu>
Newsgroups: comp.databases
Subject: Programs to manage academic bibliographies?

For several years I have been searching for software specifically designed to
organize bibliographic databases.  Records would have fields for author, title,
publisher, etc., as well as fields for subject headings, keywords, and general
comments or notes.

Finally I found an MS-DOS executable program in an archive (wuarchive.wustle.ed
u) that seems to fit the bill.  It is called Academic Reference Management Syst
em Plus (AP11.ZIP in the archive).  Ping Sing Kuo, now professor of economics i
n Taiwan, wrote it and put it in the public domain in early 1990.  Since the pr
ogram claims to fulfill precisely my cataloguing needs, I am inclined to begin
to learn how to use it.  I hesitate, for the moment, however, unfamiliar as I a
m with anyone who has had experience using that (or a similar) program.

I post in this newsgroup to draw on some of your experience and knowledge:

    1.  Have any of you used this program (AP.EXE)?

    2.  What cataloguing and retrieval needs did it serve well?

    3.  What difficulties did you have using the program?

    4.  Were the data stored in a form that could be read by
        a new or different program?

    5.  More generally, have you had good or poor experiences using
        shareware programs of this kind?

    6.  Are there other newsgroups you know of that might be able to give
        me more specific direction in my search for software to manage
        my bibliographic references?


Thank you for your assistance,

Per Fjelstad, (Ph.D. Cand.)
Rhetorical Studies,
Dept. of Speech Communication,
Penn State University
From: xxaj547@chpc.utexas.edu (Carmen Rusu)
Newsgroups: comp.databases
Subject: Unify shared memory anyone ?
Date: 22 Dec 92 18:49:23 GMT
Organization: The University of Texas System - CHPC

Hi all:

How do estimate your Unify database shared memory size needs ?

Any pointers to the answer gratefully appreciated.

Thanks
-- 
********************************************************************************
Newsgroups: comp.databases,comp.sys.novell
From: 0031@pnet16.cts.com (Capt G. Carradini)
Subject: Re: PARADOX 4.0 with Novell: Braindead?
Organization: People-Net [pnet16], NCTAMS EASTPAC
Date: Fri, 1 Jan 1993 06:56:03 GMT

We ran into problems running 3.5 on Novell 3.11.  Our fix would have been to
change the security on the directories that PDOX wanted to write in.

WRT TUTILITY wiping out forms:  if there is any restrucutring involved, PDOX
will wipe out the associated forms.  This is not fun, but it ensures forms
will not have gaping data holes or inaccurate data.  My 2 cents.

George

UUCP: humu!nctams1!pnet16!0031
ARPA: humu!nctams1!pnet16!0031@nosc.mil
INET: 0031@pnet16.cts.com
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: CASE > PARADOX CODE
Summary: Applications Workshop in Paradox 4.0 is better than PPROG
Date: 31 Dec 92 03:33:50 GMT
Reply-To: rhaven@cruzio.santa-cruz.ca.us



The Applications Worlshop in Paradox 4.0 is much better than PPROG in
3.5.  Everyone, expert PAL programmers included, should take a close
look at it.

Cheers
 Richard (Borland)
From: cheung@CAM.ORG (Shirley Cheung)
Newsgroups: comp.databases
Subject: accounting software from ftp?
Date: 30 Dec 92 07:14:25 GMT
Organization: Champlain Regional College, St-Lambert QC  CANADA


DEAR ALL!

DOES ANYBODY KNOWS THE SITE OF FTP WHERE I CAN UPLOAD SOME ACCOUNTING
SOFTWARE INTO MY PC'S? I WOULD LIKE TO HAVE "ACCPAC" OR "DACEASY"

THANKS FOR ANY REPLY

SHIRLEY
From: yenal@trbilun.bitnet (Yenal Gogebakan)
Newsgroups: comp.databases
Subject: comp.databases
Keywords: test
Date: 31 Dec 92 07:35:06 GMT
Organization: University of Bilkent-Computer Center  ANKARA/TURKEY

This is a test, plase ignore !!!


Newsgroups: comp.databases
From: 0031@pnet16.cts.com (Capt G. Carradini)
Subject: Re: How to create DBase files? (C++ Interface)
Organization: People-Net [pnet16], NCTAMS EASTPAC
Date: Wed, 30 Dec 1992 23:16:11 GMT

I would be interested in a copy of the summary.  Thanks.
George

UUCP: humu!nctams1!pnet16!0031
ARPA: humu!nctams1!pnet16!0031@nosc.mil
INET: 0031@pnet16.cts.com
From: geemic@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: Re: Explain THIS, please!
Date: 23 Dec 92 15:03:26 +1100
Distribution: world
Organization: Aust. Dept. Health, Housing and Community Services

In article <1992Dec22.163411.557@hhcs.gov.au>, champs@hhcs.gov.au writes:
> In article <1gtd91INN7ln@ef2007.efhd.ford.com>, wwm@ef5003.efhd.ford.com (Bill Meahan) writes:
>> I'm tearing my hair out at the following:
>> 
>> SQL> l
>>   1  select '%' Shift,
>>   2   p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code PartNumber,
>>   3   s.scrap_code Reason,
>>   4   SUM(s.cost) TotalDollars
>>   5   FROM cimcmms.scrap_count_history s, acg.part p
>>   6   WHERE s.part_key=p.key
>>   7    AND s.work_center_code = '75021'
>>   8    AND s.production_date BETWEEN '1-Dec-92' AND '13-Dec-92'
>>   9    AND s.shift LIKE '%'
>>  10    AND s.part_key IN ( SELECT ss.part_key
>>  11       FROM cimcmms.scrap_count_history ss
>>  12       WHERE ss.work_center_code = '75021'
>>  13        AND ss.production_date BETWEEN '1-Dec-92' AND '13-Dec-92'
>>  14        AND ss.shift LIKE '%'
>>  15        AND ROWID <11
>                  *****
> Did you mean ROWID or ROWNUM?
>                 
>>  16       GROUP BY ss.part_key
>>  17       ORDER BY SUM(ss.cost) desc )
>             **************************
>             **************************
> WARNING !  WARNING !  ORDER BYs DON'T WORK IN SUB-QUERIES
> At least they don't in our version (VAX 3.0.9.7.1).  As soon as we put an order
> by in a sub-query we got your error (group by worked fine though).  The SQL 
> reference says you can't have order by in a sub-query on insert,update, and 
> delete but does not say they're illegal in a select.
> 
> It looks to me like you're trying to retreive the 10 parts with the highest
> sum(cost).  As far as I can tell it's impossible to retrieve the top 10 groups
> of anything in a single query.  You can retrieve the top ten of something, but
> not the top 10 GROUPS of something.  Your only chance is to use PL/SQL cursors
> (though you'll have to put the results of the query in a temporary table so 
> that you can see them after the PL/SQL has finished, as the results of PL/SQL 
> statements don't echo to the screen).
> 
> Hope this helps.
> ------------------------------------------------------------------------------
>     /\       Steven Champness
>    /  \      Dept Health Housing and Community Services
>   /    \     Brisbane Queensland
>  /      \     via
> /   /    \   Canberra Australia
> \  / /   /
>  \/ / / /    MACINTOSH SOFTWARE AXIOM : If you need a manual to operate it
>   \/ / /                                it wasn't designed properly in the
>    \/ /                                 first place !
>     \/




Testing Steve...
Newsgroups: comp.databases.oracle
Subject: Terminal emulation (vt100) problem
From: joaquin@nemesis.etsimo.uniovi.es (Joaquin Ordieres Mere)
Date: Wed, 23 Dec 1992 08:08:21 GMT
Organization: Universidad de Oviedo.

Hi,

	Could someone help me, please  ???.

We are trying to use a PC (Rs232 linked) running MS-Windows and Crostalk for windows as
communication software as a oracle terminal. The trouble arises from numerical keypad,
because (I use vt100 emulation) we can't obtain numbers on oracle fields, even when the
blockNum key was pressed. Obviously when I use vi or another unix application the emulation
works fine. Is it possible that the trouble came from oracle's crt module ????

Thanks a lot.
			Joaquin.
Newsgroups: comp.databases.oracle
From: rheiger@renext.eiger.olivetti.ch (Richard H. E. Eiger)
Subject: Re: Pro*C
Reply-To: rheiger@renext.eiger.olivetti.ch
Organization: Olivetti (Schweiz) AG, Branch Office Berne
Date: Sun, 20 Dec 1992 10:52:29 GMT

In article <1992Dec17.220804.12585@tigger.jvnc.net> fogelinc@nmr1.Cyanamid.COM  
(Carl Fogelin) writes:
> In article 13161@den.mmc.com, richard@crowded-house.den.mmc.com (Richard  
Armstrong) writes:
> >
> >I have plenty of good things to say about Oracle Pro*C. However, let me
> >focus on one area where I find Pro*C completely brain-dead.
> >
> [stuff deleted]
> >
> >Why doesn't the Pro*C precompiler do #define substitutions?
> 
> Because the scope of the Pro*C preprocessor would probably get out of hand.
> Sure, it would be nice if the Pro*C preprocessor would at least recognize 
> #defines which are at the top of the current module, but the c preprocessor
> can be much more complicated.  What about #defines found in an #include file?
> What about #defines which use conditional assignments (i.e., #ifdef)?  These
> are just a couple of complications, but if you think about it, I'm sure you
> can come up with more.
> 
> Yes, I agree that I wish Pro*C did the #define substitutions, but I  
understand
> why they didn't do it.  What I don't understand is why "struct"ures are not
> valid for host variables, but VARCHARs (which are structures) are...  8-(
> 
> -------------------------------------
> Carl Fogelin (fogelinc@cyanamid.com) 
> 

The problems described here are a nuisance, I agree. But there are things I  
find much much worse in PRO*C. For instance, you can specify ireclen and  
oreclen. But, PRO*C still has an upper limit. When that is reached your output  
will be erratic without warning!

The other real stupidity is that PRO*C is not clever enough to put "#line nnn  
file.pc" statements into the output. It would be so much less of a pain to find  
errors in the .pc source when the C-compiler complains. And also runtime output  
from the assert macro would finally be useful.

The solution to this is to preprocess the .pc file before feeding it to pcc.

	Just my 2 cents.
	Richard
--
                         
    ___           _____2
   /   )  /  /   /        Richard H. E. Eiger
  /_ _/  /__/   /__       Ing. Informatik HTL
 /\     /  /   /          Unregistered NeXT fan
/  \   /  /   /_____      rheiger@renext.eiger.olivetti.ch (NeXT mail welcome)
Newsgroups: comp.databases.oracle
From: aaj@cmutual.com.au (Tony Jambu)
Subject: Re: Question using BETWEEN/AND cond with NEXT_DAY/DAY math
Organization: Colonial Mutual Group 
Date: Thu, 24 Dec 1992 03:21:57 GMT


In article <echoy.724882423@cunews>, echoy@alfred.carleton.ca (Eugene Choy)
writes:
>
stuff deleted
>
> Now, consider this statement 
>    (assume NEXT_DAY(sysdate,'sunday') returns 3-jan-93):
> ----------------------------
> SELECT 'ok' FROM DUAL 
> WHERE
>    to_date('1-jan-93','dd-mm-yy') BETWEEN
>    NEXT_DAY(sysdate,'sunday')-2 AND
>    NEXT_DAY(sysdate,'sunday');
> ----------------------------
> this does not return 'ok'!!!!!
> why is this the case? since,     
>    NEXT_DAY(sysdate,'sunday')-2                 means 01-jan-93
>    NEXT_DAY(sysdate,'sunday')                   means 03-jan-93
> 

I know you said 'assume NEXT_DAY(sysdate,'sunday') returns 3-jan-93' but
I believe if you run the query on between the 27th Dec 1992 and 2nd Jan 1993
you
should get the right answer.

Why not try

SELECT 'ok' FROM DUAL
WHERE
   to_date('26-DEC-92','dd-mon-yy') BETWEEN
   NEXT_DAY(sysdate,'sunday')-2 AND
   NEXT_DAY(sysdate,'sunday');
now.

It gives the correct result.



-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Invest Mgmt Aust (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
 \_______/                   |PHONE:  +61-3-6418448       FAX:  +61-3-6076198
From: btreuman@ems.cdc.com (Bob Treumann)
Newsgroups: comp.databases.oracle
Subject: Re: ORACLE ftp sites
Keywords: ORACLE FTP
Date: 30 Dec 92 00:48:04 GMT
Reply-To: btreuman@ems.cdc.com
Organization: Empros Systems International, a division of CDC

In article <479@ptt-iat>, roo@ptt-iat (? Roo) writes:
|> Hi,
|> 
|> 
|> I'm looking for ftp sites where I can find ORACLE stuff.
|> Especially I'm looking for DBA utilities.
|> Can anyone e-mail the addresses of some sites to me ?
|> 
|> Thanks in advance
|> 
|> 
|> Peter de Roo.


I would like to know this too.
From: mickel@OES.ORST.EDU (Paul M. Mickel)
Newsgroups: comp.databases.oracle
Subject: Re: What is SQL*FOMS
Date: 30 Dec 1992 23:12:01 GMT
Organization: Oregon Extension Service, Oregon State University, Corvallis, Or.
NNTP-Posting-Host: oes.orst.edu

In article <1992Dec30.165249.1331@ms.uky.edu> naveen@ms.uky.edu (Naveen Goud) writes:
>Hello Nettors,
>
>I would like to know what is SQL*FORMS. I have used Oracle and manipulated the
>data in the database using SQL queries. Other than this I have not worked
>with any other tools of the ORACLE products.
>
>Could someone explain the SQL*FORMS

SQL*FORMS is a program included with Oracle that allows one to generate 
forms that are based on database tables. This is most useful in develop-
ing input and query forms for people that don't know or want to know how
to use SQL at the database level. It also has capabilities for improving
data integrity. You can also performany number tasks based on certain
"events", like moving to a particular field, etc. 

-pmm




-- 
Paul M. Mickel			  	   Internet:mickel@oes.orst.edu
Sysadmin, Oregon Extension Service	   Corvallis, OR 97331
Database Programmer, Teledyne Wah Chang    Albany, OR 
Disclaimer: Neither employer has *ever* claimed any of my opinions.
Newsgroups: comp.databases.oracle
From: jhs@n8ppd001.nt.com (jhs)
Subject: Re: Looking for Mac report writer
Reply-To: cmjxs04@nt.com (jhs)
Organization: Northern Telecom,  RTP NC
Date: Mon, 21 Dec 1992 15:47:46 GMT


SQR is available for the MAC.  It uses Oracle's SQL*Net to access
the database.  The interface is not very pretty and the Mac version
does not support postscript output, but otherwise it is completely
compatible with the current UNIXSQR.

john
From: roo@ptt-iat (? Roo)
Newsgroups: comp.databases.oracle
Subject: ORACLE ftp sites
Keywords: ORACLE FTP
Date: 23 Dec 92 15:59:10 GMT
Organization: PTT Telecom B.V. I&AT NWDS-DS-OOTA , Groningen The Netherlands

Hi,


I'm looking for ftp sites where I can find ORACLE stuff.
Especially I'm looking for DBA utilities.
Can anyone e-mail the addresses of some sites to me ?

Thanks in advance


Peter de Roo.
Newsgroups: comp.databases.oracle
From: hietanen@lut.fi (Pentti Hietanen)
Subject: 40 values in desc order
Date: Tue, 22 Dec 1992 15:24:35 GMT
Organization: Lappeenranta University of Technology, Finland

Hello!

With my thesis there is a problem:

What kind of sql sentence should we use to get 40 values
from database in descending order?

We know how to get values from sysdate-30 days or like that, but
how to spesific amount of values?

Thanks for you help!

Pentti Hietanen, student of Lappeenranta University of Technology, Finland.
internet: hietanen%lut.fi
Newsgroups: comp.databases.oracle
From: mike@cray.com (Mike Carney)
Subject: Re: Question using BETWEEN/AND cond with NEXT_D
Reply-To: mike@cray.com
Organization: Cray Research, Inc.
Date: 22 Dec 92 14:04:43 CST

You have to be careful using date/time fields with the BETWEEN/AND operator.
The date field may contain time as well as the date -- sysdate for example
has both a date and a time component.  The trunc function can be used to 
remove the time component.  Example:

SQL> select 'ok' from dual where sysdate = '22-dec-92';

no rows selected

SQL> select 'ok' from dual where trunc(sysdate) = '22-dec-92';

'O
--
ok

 
---

Mike Carney  mike@cray.com         Cray Research, Inc.    (612) 683-5635