问题 |
constraint name uniqueness,existence of index column |
Reference constraint name maximum length is limited to 7 characters |
Key constraint name maximum length is limited to 7 characters |
Table code maximum length |
Key constraint name maximun length is limited to 15 characters |
Column code maximum length |
默认生成的SQL语句(表名、字段名等)都带双引号,导致用SQLPlus插入Oracle数据库时表名与表列都带""号
|
解决方法 |
点击右键选择Automatic correction |
菜单:Database=>Edit current DBMS PGSQL73::Script/Objects/MaxConstLen value=>255 PGSQL73::Script/Objects/Table/Maxlen value=>255 |
修改DataBase->Edit Current DBMS->Script->Objects->MaxConstLen值为128 |
Database=>Edit current DBMS 数据库类型::Script/Objects/Column/Maxlen value=>255 |
但是要注意的是,表名、列名、主键等不要超过30个字符,否则Oracle不认。 |
Database-> Edit Current DBMS...-> Script-> Sql-> Format-> CaseSensitivityUsingQuote 改为No |