Hey guys!
I am TJ Abrahamsen, with OracleTuts.
In this video I will show you how you can use PL/SQL Developer from Allround Automations to import a text file, in my case a .CSV file into a simple table.
This tool can be used for many types of data imports into an Oracle table.
I hope you find the little video helpful.
~ TJ
Nguồn: https://12m-15m.org/
Xem thêm bài viết khác: https://12m-15m.org/category/cong-nghe
THANKS MAN
IT WAS VERY HELPFULL FOR ME!
Thank you!
Thanks for sharing 😊
Very pooooor vedio quality
Superb. Thanks.
Excellent…Thanks!
soja muna nahi tho rajnikant aajayega
Excellent THANKS .!!
Excellent
May I know what version of pl/sql developer you are using? Mine is 7.1.4 and when I click on TOOLS I don't see all those options, to be specific I am looking for CONNECTIONS
Thanks!
Thanks for the instructive video, this was exactly the type of thing I was looking for !
tj take a nap first
Very good tutorial. Plain and simple. Great help. Thanks 🙂
Created a text file that had 4.7 million records in it, with five columns. The itool seems to handle the file well. Had to kill the process after 1.7 million, since my session seemed to make my PL/SQL Developer "hang" and i needed something in another open window. But, it was still doing it's job well. Think this might be a setup issue (multi session, etc.). Anyhow…it took about 40 minutes to import 1.7 million records, where I set it to commit every 500 records. So, it is doing it's stuff.
Hi Ralph. Thanks for the feedback. I have been very busy privately the last couple of months. I will try to make some more videos soon.
Sorry for the late feedback. I have not tried it on large files yet. But, here is a reply to someone asking Allround Automations a similar question: Search Google for "Text Importer File Size Limit"
Thanks! I'm new to Oracle, and I've been watching a lot of Chris Ostrowski's videos, but it's good to see stuff in PLSQL Developer (which I'm using) instead of Oracle's SQL Developer. I was actually looking for the Table Import & Export functions (I only found Chris's video on Export, and he uses the command line – looks like this is much nicer in PLSQL Developer). Hope you do more videos soon. I'd love to see stuff on Procedures and Packages, too.
Is it faster than sqlldr ? I have a million records to load !
Yeah…I just got the dummy data from somewhere..