Hi ,
I need to put in the contents of a file in an element,
How can i do it ,as i have tried to create a .sql file with a update in it ,but it gives an error.
I think we need more information. What kind of error? What kind of file (text/binary)?
By the way, you can open file in Oracle using the UTL_FILE package...
Oh, I didn't understood you!
You can insert every line of the file separately, using varchar2 type.
Or you can insert the whole file as an only element, then you surely will need the clob type.
Anyway, you'll have to open the file, read it's contents and insert them to the table. You can do that with a procedure.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.