AW: UTL_FILE pkg related issue

From: Maxim Demenko <Maxim.Demenko_at_loyaltypartner.com>
Date: Tue, 05 Jun 2001 09:11:12 -0700
Message-ID: <F001.0031C354.20010605082602@fatcity.com>

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: maxim.demenko_at_loyaltypartner.com
www.loyaltypartner.com
www.payback.de  

-----Ursprüngliche Nachricht-----
Von: Vikas Kawatra [mailto:VKawatra_at_innoventry.com] 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: VKawatra_at_innoventry.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_at_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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maxim Demenko
  INET: Maxim.Demenko_at_loyaltypartner.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_at_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).

Received on Tue Jun 05 2001 - 11:11:12 CDT