RE: Count rows in textfile

Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g644VB218478 for ; Thu, 4 Jul 2002 00:31:11 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id NAA75226; Wed, 3 Jul 2002 13:30:31 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 0048F6E2; Wed, 03 Jul 2002 13:22:16 -0800 Message-ID: Date: Wed, 03 Jul 2002 13:22:16 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Igor Neyman" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Igor Neyman" Subject: Re: Count rows in textfile Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01BB_01C222AE.4DF486C0" ------=_NextPart_000_01BB_01C222AE.4DF486C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Count rows in textfileI guess, Jared allows this thread to continue = only because it's pre-holiday :-) Igor Neyman, OCP DBA ineyman@perceptron.com =20 ----- Original Message -----=20 From: Whittle Jerome Contr NCI=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, July 03, 2002 4:49 PM Subject: RE: Count rows in textfile Something like Schrodinger's Cat! Jerry Whittle ACIFICS DBA NCI Information Systems Inc. jerome.whittle@scott.af.mil 618-622-4145 -----Original Message----- From: Fink, Dan [SMTP:Dan.Fink@mdx.com] We are all missing the point. Without opening the file, it must be = observed from the outside. As such, from this observation point, it = contains no rows. Thus, the method is irrelevant as the answer will = always be 'NONE'. -----Original Message----- From: Whittle Jerome Contr NCI = [mailto:Jerome.Whittle@scott.af.mil] If the room is dark, you may need to step on tails and count the = YYYYYRRRRRrrrrrrrrssssss you hear. Of course, duplicates could still be = a problem. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. jerome.whittle@scott.af.mil 618-622-4145=20 -----Original Message----- From: Rachel Carmichael [SMTP:wisernet100@yahoo.com]=20 gee, for simplicity's sake, I usually just count tails :)=20 --- Tim Gorman wrote: > Count the eyes and divide by 2... > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" = > > > Roland, > > > > How about counting black cats in the dark room without turning = on > the light? > > > > Igor Neyman, OCP DBA > > ineyman@perceptron.com > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" = > > > > > Anyone whom has a good example on how to check "how many = rows > (without opening the file) does a text file consists of? > > > What is the command? > > > > > > Thanks in advance > > > > > > Roland=20 ------=_NextPart_000_01BB_01C222AE.4DF486C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Count rows in textfile

I guess, Jared allows this thread to continue only = because=20 it's pre-holiday :-)

Igor Neyman, OCP DBA
ineyman@perceptron.com
&nbs= p;=20

----- Original Message -----

From:=20 Whittle Jerome Contr = NCI

To: Multiple recipients of list = ORACLE-L=20

Sent: Wednesday, July 03, 2002 = 4:49=20 PM

Subject: RE: Count rows in = textfile

Something like=20 Schrodinger's Cat!

Jerry = Whittle

ACIFICS = DBA

NCI Information = Systems=20 Inc.

jerome.whittle@scott.af.mil

618-622-4145

-----Original=20 Message-----

From: Fink, Dan=20 [SMTP:Dan.Fink@mdx.com]

We are all=20 missing the point. Without opening the file, it must be observed = from the=20 outside. As such, from this observation point, it contains no rows. = Thus,=20 the method is irrelevant as the answer will always be=20 'NONE'.

-----Original=20 Message-----
From: Whittle Jerome Contr NCI [mailto:Jerome.Whittle@scott.a= f.mil]

If the=20 room is dark, you may need to step on tails and count the=20 YYYYYRRRRRrrrrrrrrssssss you hear. Of course, duplicates could = still be a=20 problem.

Jerry = Whittle
ACIFICS DBA
NCI Information Systems = Inc.
jerome.whittle@scott.af.mil
618-622-4145

-----Original=20 Message-----
From: = Rachel Carmichael=20 [SMTP:wisernet100@yahoo.com] =

gee, = for simplicity's=20 sake, I usually just count tails :)=20

--- = Tim Gorman=20 <Tim@SageLogix.com> wrote:
> Count the eyes and divide by = 2...
>
> ----- Original Message = -----
> To: = "Multiple=20 recipients of list ORACLE-L" = <ORACLE-L@fatcity.com>
>
> > Roland,
> = >
> > How = about counting=20 black cats in the dark room without turning on
> the = light?
> = >
> > Igor = Neyman, OCP=20 DBA
> >=20 ineyman@perceptron.com
> >
> > ----- Original Message -----
> > To: = "Multiple=20 recipients of list ORACLE-L" = <ORACLE-L@fatcity.com>
> = >
> > > = Anyone whom=20 has a good example on how to check "how many rows
> (without = opening the=20 file) does a text file consists of?
> > > = What is the=20 command?
>=20 > >
>=20 > > Thanks in advance
> > >
> > > Roland=20

------=_NextPart_000_01BB_01C222AE.4DF486C0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: ineyman@perceptron.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).