OraFAQ Forum: Data Integration » flat file as a target table and external table

Home » Developer & Programmer » Data Integration » flat file as a target table and external table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

flat file as a target table and external table [message #211978]

Wed, 03 January 2007 05:44

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

Report message to a moderator

Re: flat file as a target table and external table [message #211987 is a reply to message #211978]

Wed, 03 January 2007 06:20

Littlefoot
Messages: 21823
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

Report message to a moderator

Previous Topic:	SQL LOADER - filenames
Next Topic:	runnig unix script before the mapping

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 18:23:48 CST 2024