How To Perform A Text Import With PL/SQL Developer

[@RMAmbrose]

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.

[@oracletuts]

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.

[@kingcrimson1005]

Hi, I need to import a csv file having a column 7000 characters long. I've tried to use SUBSTR but the sintax SUBSTR(,1,4000) or SUBSTR(#,1,4000) doesn't work. Can yoiu help me?

[@sirnigel100]

Thanks for the instructive video, this was exactly the type of thing I was looking for !

[@oracletuts]

You are welcome. My first TH-cam video :-)

[@VSACrimDawn]

Great video! Thank you a lot!

[@owaisquadri3980]

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!

[@gonzalomaidana5429]

THANKS MAN
IT WAS VERY HELPFULL FOR ME!

[@oracletuts]

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.

[@paulazemeckis7835]

I keep getting ORA-01722 invalid number error msg. There are just 2 fields, member id and month. In excel the fields are "General" format. I saved the Excel file as a .cvs file. It still gives me an error msg no matter what!🤬

[@oracletuts]

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"

[@МединаЛи-ю9т]

It can’t see my csv file’s records?

[@ujjwalkarn30]

Thanks for sharing 😊

[@rasandik99]

Is it faster than sqlldr ? I have a million records to load !

[@rajvallamkondu1492]

Excellent...Thanks!

[@oracletuts]

Yeah...I just got the dummy data from somewhere..

[@tundeakeemladipo5690]

Excellent

[@lonnyds]

Thank you!

[@pablotorres5668]

Excellent THANKS .!!

[@ScramblerVibes]

soja muna nahi tho rajnikant aajayega

[@massefromla2554]

tj take a nap first

[@oracletuts]

Hi there. Thank you for the feedback. ;-)

[@rajendrabangar4418]

Very pooooor vedio quality

[@zacharyzimmerman7629]

Superb. Thanks.