read text

Hi all

I need to read some parts of text file and put it to oracle?
(only numeric)
Ex. 'total 11202 555498 all 54877 18177' a row on text file. I know the sequence of this row what means and it's only
row that I need from text file

Now, I need to get 11202,555498,54877,18177 from it and put each values to database.
What sql command help me?

I think I should search 'total on text files' and read next till the next string isn't blank and read & write till the next string is blank.

What sql command help me?

None of the SQL commands can do text reads. You can use :

a) sql*loader utility or

b) TEXT_IO package inside Oracle Developer or

c) UTL_FILE built-in package or

d) write a Java stored procedure to do it

Check in the Oracle manuals for more details & examples.