1

Topic: How correctly to make

Help to eat the type text file, please,
;2017; 05; 33; 330249; IVANOV AND AND; 02; 32; 22524; 5; ; ; 3; 17000; 2092,48; 2092,48;
;2017; 05; 33; 330249; Ivanov And And; 02; 32; 22524; 5; ; ; 4; 22600; 36536,99; 36536,99;
It is necessary to load in the table each value on lines in a separate field

2

Re: How correctly to make

The tool needs to be selected depending on a task singularity
On a choice:
Regular candidate solution of a problem - SQL*Loader ( external table as a variant)
The built in means import from external file yours IDE: SQL Developer/SQL Developer
Exotic method but to edit/transform a text file/stream in commands insert sometimes easier
Loading of lines as lines in the table, and the subsequent analysis of lines in PL/SQL with  on fields, it is convenient when error handling or difficult transformation of the data is required

3

Re: How correctly to make

That's just the point that SQL*Loader (external table as the variant) does not approach

4

Re: How correctly to make

Other variant - to consider line by line a file (utl_file) from a directory (oracle directory), to select string functions necessary values (substr + instr), to consider regional settings for decimal point at conversion in number (NLS decimal separator + to_number)

5

Re: How correctly to make

tatyana_ppp wrote:

That's just the point that SQL*Loader (external table as the variant) does not approach

Announce all list please
Telepathists it is necessary is not present
Than does not approach?
1) As often it is necessary for you to fulfill loading: razovo/periodically
2) Data volume (order) /// bytes
3) Loading is fulfilled from the server or the client
4) the Source: Data files are formed by your application, downloaded from exterior sites, are on a disk
5) That you made, why does not approach SQL*Loader, what errors (not in retelling and  loadings in a text type, pictures it is not necessary is better)
6) whether data transformation (for example error check) is necessary
7) whether Is constraint/index on the table
Depending on answers, recommendations will be different

6

Re: How correctly to make

+ Here it to decrypt -

tatyana_ppp wrote:

each value on lines in a separate field

7

Re: How correctly to make

tatyana_ppp wrote:

That's just the point that SQL*Loader (external table as the variant) does not approach

And than it does not approach?
SY.