How to change default field type when importing csv
已回答
When importing csv data into an Oracle database text fields are automatically coaxed to CLOB fields (instead of VARCHAR2). There are multiple bug reports relating to this issue (https://youtrack.jetbrains.com/issue/DBE-11753) but I don't think this will be fixed anytime soon.
Is there a setting somewhere in the config files where we can change this ourselves?
请先登录再写评论。
When importing the file you can click on the "DDL Preview" and change the data type.