Category: XlsToOra
-
How to edit Oracle field data type in SQL Developer
1. Click table name in left tree. 2. Click the “Edit” button. 3. then will show “Edit Table” form, select the field you want to edit in “Columns” list. 4. Then you can change the “Type”, here is from “CLOB” to “NCLOB”. Click “OK”. Done!
-
Notes about Import Unicode data from Excel to Oracle
1. Download FileToDB from here. 2. Check “UseUnicode” box on Oracle logon window. 3. Create your field as “NCLOB”, not “CLOB”.