This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
with file name as data.ctl or data.txt
"AAAS",POTSA,INSTALAL,RETAILS,RESIDENTIALA,NA,STANDARDA,OUT,N,73,07:00 pM,02:00 PM,7,01:00 AM
There is no LOAD DATA command in Oracle's SQL, and as far as I know, neither in SQL Developer. Oracle has SQLLoader utility for loading up values from text files, or much better external tables feature from version 10 on (maybe in Oracle 9 too, don't remember clearly), and you might be able to reformat the data to conform to these tools, but it'll be some work (lots of work if you're not familiar with Oracle) and you should look it up in the documentation first.
For smaller data sets usually plain scripts (with CREATE TABLE and lots of INSERT statements) are generated. If you can generate these form MySQL, it might be the easiest way to go. The second option would be to export data to some intermediate format - eg. CSV or XML, SQL Developer should be able to import this, if you create the table(s) first.