RE: Spooling to a flat file via SQL*Plus

anusz fsys.com>cc: Sent by: Subject: RE: Spooling to a flat file via SQL*Plus [EMAIL P

RE: Spooling to a flat file via SQL*Plus

Cheri, What about INSERT INTO new_table SELECT a,SUBSTR(b,1,255),c,d,e FROM old_table; Just a thought. Mike -Original Message- Sent: Wednesday, December 12, 2001 10:00 AM To: Multiple recipients of list ORACLE-L I need to chang a column in an existing table from varchar2(2000) inste

RE: Spooling to a flat file via SQL*Plus

ROTECTED]'" <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> at

RE: Spooling to a flat file via SQL*Plus

Just in case there are MORE than 1 Rows, you can simply set PAGES 0 instead. Martin -Original Message- Thomas F Sent: 12 December 2001 15:35 To: Multiple recipients of list ORACLE-L CHerie, Why not just move the data directly using sqlplus rather than go the sqlloader route: inse

RE: Spooling to a flat file via SQL*Plus

CHerie, Why not just move the data directly using sqlplus rather than go the sqlloader route: insert new_cd_experience(KS_EXPERIENCEID,EXP_NOTES, EXP_QA_STATE,TEMP_RN,EXP_REVIEW_NEEDED) select KS_EXPERIENCEID,substr(EXP_NOTES,1,255), EXP_QA_STATE

RE: Spooling to a flat file via SQL*Plus

Hi Cherie, SET HEADING OFF SPOOL C:\TEMP\output.txt SELECT KS_EXPERIENCEID||','||SUBSTR(EXP_NOTES, 1, 255)||'-'||EXP_QA_STATE||'-' ||TEMP_RN||','||EXP_REVIEW_NEEDED FROM YOURTABLE set heading on spool off This would create your file. Luck Ramon E. Estevez [EMAIL PROTECTED]

RE: Spooling to a flat file via SQL*Plus

Cherie: If there are any commas in the date fields you will have problems with a comma delimited file. You may want to try "~" tilde delimited instead. My $0.02, Ken -Original Message- Sent: Wednesday, December 12, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Subject: