This content has been marked as final. Show 4 replies
This really is a general SQL question and really has nothing to do with SQL Developer.
I suggest you check the forum on Oracle bulk load program, SQLLDR
Actually, in SQL Developer, you can open a connection to the target schema, right-click on the Tables node in the navigator tree view, select Import Data, then use the Data Import Wizard. It is extremely flexible. It looks like you have a comma separated variable file, so if you select Format: csv and Import Method: insert it will probably work just fine.
To minimize the chance of errors during import, pick a preview limit value so the wizard can examine the size and data type of all columns in as many data rows as possible, then review the data type/size for each column in the next wizard page and override as necessary. For date columns it is also important to choose the appropriate format mask.
Hope this helps,
SQL Developer Team
Thanks for the info...:)
but i am learning pl/sql with XML..that why i am asking this question...could you please explain me with pl/sql code..