regarding bulk data access

I need to access bulk data from a table and populate a flat file.

I would like to know the most efficient way in which i can achieve this.

Please note that a table can contain few hundred thousand records.

I would appreciate certain guidelines from someone who has done something like this.

Thanks and Regards,

Sachin.

[355 byte] By [this_is_the_coolest_guya] at [2007-10-3 5:25:23]

# 1

Hi ,

ORACLE SPOOLING .

SPOOL a.dat

TTITLEleft '' skip 1 -

left 'Date :' xTODAY COL 47 'ONLINE/BATCH EXCEPTION REPORT 'COL 115 'Page:' format 99999999999 sql.pno SKIP 2 -

COL 47 'Latest EXCEPTION REPORT File Generated :' YTODAY SKIP 2 -

column Today NEW_VALUExTODAY noprint format a20

column GenToday NEW_VALUE YTODAY noprint format a20

column ID_LOGheading 'LOG ID' format 999999999999999999999999999justify right

column CD_LOG_MESSAGEheading 'LOG MESSAGE' format a15

column TX_DESC_MESSAGEheading 'LOG DESCRIPTION'format a80

column TM_LOGGED heading 'LOG TIME' format a23

column NM_RAISED_BY_OBJheading 'RAISED BY' format a40

column IN_ORIGINheading 'ONLINE/ BATCH' format a20

column ID_LOG_LVLheading 'LEVEL'format 999999justify right

column NM_TABLEheading 'TABLE'format a30

column NM_KEYheading 'KEY'format a60

column VL_KEY_VALUEheading 'KEY VALUE' format a60

column no_data_foundheading 'NO DATA' format a95 justify center

select ..... from LOG table

TTITLE OFF

SPOOL OFF

CLEAR BREAKS

avina_helloa at 2007-7-14 23:32:35 >

# 2

Sorry to mention ...the database i m using is MySql.Thanks,Sachin.

this_is_the_coolest_guya at 2007-7-14 23:32:35 >

Database Connectivity New Topic