Home » Developer & Programmer » Data Integration » flat file as a target table and external table
flat file as a target table and external table [message #211978] Wed, 03 January 2007 05:44 Go to next message
ashraf_oh@hotmail.com
Messages: 9
Registered: October 2006
Location: Egypt
Junior Member
Dear all Collegue

kindly please help me in the following
1- i need to extract data from a relational table and load it in a target flat file . i need the steps ?

2- i need an example for how to use external table

bets regards;
ashraf hussein
Re: flat file as a target table and external table [message #211987 is a reply to message #211978] Wed, 03 January 2007 06:20 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
For the first one, you could spool SELECT statement's result (using SPOOL SQL*Plus command). Or, using a PL/SQL, you could try with DBMS_OUTPUT (for output < 1.000.000 bytes) or UTL_FILE packages.
For the second one, you already know the keywords: "external table". Use Google and search for it or /forum/fa/1681/0/
Previous Topic: SQL LOADER - filenames
Next Topic: runnig unix script before the mapping
Goto Forum:
  


Current Time: Fri Mar 29 09:19:32 CDT 2024