-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|