var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: write from a table toa file
Hi all friends:
I need to pass the information from a table in oracle to a file, this file munst contain the rows in the next format
and this table contains thounsands on rows, maybe millions, so, my question is
what's the best way to do this???
I know i can program an app which take every register from the table and write the file, and i know i can use Data import and export tool of Sql Server.
Or there is a better way, maybe with an Stored Procedure???
ThanX for all
from SQL*Plus use the SPOOL command
You can use spool to output sql to a text file using concatenation with your columns.
Use environment variables to set sql up to make the file look like you want ... ie, set heading off, set linesize xxx, set pagesize 0,
set termout off ..... etc