Oracle reads the data of the text file:
That is, I have a Test file, there is 1.TXT, 2.TXT, 3.TXT, 4.TXT ... N.TXT, etc. (imported to database table test). *. TXT format data
For example, 1, AAA
2, BBB
3, CCC
4, DDD
Wait
TEST table field name autoid Number,
Name varchar2 (10),
I understand the use of the SQL * loader command to load * .txt.
If I want to write a storage process to read a lot of text files inserted into the table,
How do I load the data in the text file in the stored procedure into the database table? Is there a way to adjust in the stored procedure
Use Sqlloader's function?
I don't know if I can implement, help! Everyone helps help! ?
