Is there a function to add SQL or Comments before or after generated DDL? And do there access-able properties exist in data modeler?
What I would like to do is for every generated DDL I add an insert statement into a version table in the DB with e.g. the data modeler file name (if you version by copying the data modeler files) or the SVN Revision Nr.
e.g.
*****************************************************************************************************
-- Generiert von Oracle SQL Developer Data Modeler 4.0.1.836
-- am/um: 2014-05-08 15:43:16 MESZ
-- Site: Oracle Database 11g
-- Typ: Oracle Database 11g
-- Before insert
-- Generated DDL
<SOME DDL STATEMENTS>
-- Zusammenfassungsbericht für Oracle SQL Developer Data Modeler:
--
-- CREATE TABLE 0
-- CREATE INDEX 0
-- CREATE VIEW 0
-- ALTER TABLE 0
-- ALTER INDEX 0
-- DROP TABLE 0
-- DROP INDEX 0
-- CREATE TRIGGER 0
-- ALTER TRIGGER 0
-- CREATE SEQUENCE 0
-- ALTER SEQUENCE 0
-- DROP SEQUENCE 0
-- CREATE MATERIALIZED VIEW 0
-- DROP VIEW 0
-- ERRORS 0
-- WARNINGS 0
-- After insert
insert into my_db_version_table values (sysdate, #{SQL-DB-MODELER-SVN-REVISION-NUMBER}, xxx, yyy)
*****************************************************************************************************
Greetings Max