Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Sun, 02 Feb 2003 16:41:39 -0600 Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: Text-file From: weberm@polaris.net (Ubiquitous) X-Newsreader: WinVN 0.99.10 (beta 4) [de] (x86 32bit) References: Message-ID: Date: Sun, 02 Feb 2003 16:41:39 -0600 Lines: 17 NNTP-Posting-Host: 68.35.210.171 X-Trace: sv3-DwUkghRk4CASDRv7uU/yzBxENYpcoL57wA1IKI2iQnK57lCizsRwYeifP33PaJfG4bfn++/JuXwUQYJ!Eg3UsBRAavJdoM0/gP2eY93pk12wKojzijuif3PNTc3htLvEZBEWq0rp7SlVQA== X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 Xref: newsfeed1.easynews.com comp.databases.oracle.misc:92615 comp.databases.oracle.server:174533 X-Received-Date: Sun, 02 Feb 2003 15:40:59 MST (news.easynews.com) In article , s.lehaire@meilleuregestion.com wrote: >I know that is possible to write into a file the resultset of a >query with the spool option, but is it possible to read a text file >to put the data into a table ? There's two ways to do this: SQL*LOADER or A script which reads the file one line at a time (performing edits, if desired) and performing INSERT statements. -- ====================================================================== ISLAM: Winning the hearts and minds of the world, one bomb at a time.