The term of NUMBER OF ROWS is not quite appliable in case of binary file.
Anyway wc -l yourfilename (i suggest you are in unix shell , otherwise you
can compile the '\n' counter like this
--------------------------------------
#include <stdio.h>
main()
{
int counter=0,c;
while((c=getchar())!=EOF)
if(c=='\n')
counter++;
printf("%d\n",counter);
}
-------------------------------------
)
HTH
~~~~~~~~~~~~~~~~~~~~~~~~
Maxim Demenko
Database Specialist
LOYALTY PARTNER GmbH
Landshuter Allee 12-14
80637 München
Tel: +49(0)89-99741-628
Fax: +49(0)89-99741-629
email: [EMAIL PROTECTED]
www.loyaltypartner.com
www.payback.de
-----Ursprüngliche Nachricht-----
Von: Vikas Kawatra [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 4. Juni 2001 21:32
An: Multiple recipients of list ORACLE-L
Betreff: UTL_FILE pkg related issue
I use the UTL_FILE pkg to read a bin file and load the data into our
database tables (insert or update) . The program works fine - but since we
do updates too- we would like to protect out table - by checking the no of
rows in the input file - The file has a Header and Tail - CAn someone
suggest - how I can scan the binary file - and count the no of rows - before
- processing the file ?
thanks
vikas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vikas Kawatra
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maxim Demenko
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
