Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I properly append a prefix to a table name or column using SQL Developer?

3197448Mar 14 2016 — edited Mar 18 2016

Hi,

I am new to the world of SQL developer and have been trying to use some of the examples that were provided with the base installation. I am looking to add a prefix to a table name using transformation scripts.. I am able to add it but when I perform a ddl preview the table name is now surrounded in double quotes i.e. "Table Name". Is there some kind of append or concat method that I can leverage via the tableName or cname object?

//get column name

cname = column.getName();

prefix = "XXT_";

column.setName(prefix + cname.substring(count));

table.setDirty(true);

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2016
Added on Mar 14 2016
5 comments
3,031 views