Re: SQL*Loader

Hi All!
Mark Gumbs пишет в сообщении <3703675d.0_at_145.227.194.253> ...

>Does anyone know how to specify the rows you want imported into a table?
>For example, i have a CSV file of 10 fields and a table with 5 fields. I
>want to specify which fields i want from the CSV into the table.

This problem over SQL*Loader solve a hard Optimal - uses UTL_FILE packages (if you have Oracle 7.3 and later)

You can read first record in CSV datafile Analyze and fill tempory table of next record values

Over SQL*Loader
You must create two CTL file - first for detecting column name

desc scott.loadcolname
  ID number(10)
  Collumn_Name varchar2(50)

desc scott.loaddata
 COL1 VARCHAR2(50),
 COL2 VARCHAR2(50),
 ..
 COL5 VARCHAR2(50) and second for load date as TEXT
(You can use keyword TERMINATED BY ';' for direct delimiter char)

on finish load - EXECUTE spetials PROCEDURE or FUNCTION for distribution date in work tables

Best regards
Всех Благ
---
Origin ... Просто надо очень верить этим синим маякам... Romanov Alexander
Alexander.Romanov_at_usa.net
ICQ 6220754 Received on Thu Apr 01 1999 - 09:47:13 CST