Skip to Content

Powerdesigner, double quotes issue

The scripts generated by our data model are used across many Oracle DB instances, where the tablespace names are specific to the instance in question. To facilitate this, our tablespace names in the model are prefixed with ampersand (&) or double &&, e.g. &&TABLESPACE_DATA or &&TABLESPACE_INDEX. Ampersand is how you get Oracle's SQL running tool, SQL * Plus to prompt for substitution - allowing us to enter the instance specific name. We added ampersand to the allowed chars for CODE in Tools|Model Options|Naming Convention, but the problem is PD seems to double quote ampersand prefixed names / codes, which is undesirable as double quotes mean any reference to the tablespace in Oracle has to be double quoted - Oracle is case insensitive unless things are double quoted.

What setting can we use to prevent PD from apply double quoting to ampersand prefixed names/codes?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers