DBTool-Help


Command Substitution    [Back to Content]

Placeholders for commands or sections of commands can be used. So its possible to use the same command for ORACLE, MySQL and PostgreSQL.
Placeholders are defined in the file replacements.xml.

E.g.: With the given placeholders the command :
select ${datelong(databasetime)}, ${nullvalue(thiscolumn,'---')}, anothercolumn from sometable

will be executed on ORACLE as:
select to_char(databasetime,'DD.MM.YYYY'), nvl(thiscolumn,'---'), anothercolumn from sometable

and on MySQL as:
select date_format(databasetime,'%d.%m.%Y'), IFNULL(thiscolumn,'---'), anothercolumn from sometable

Sure you can add replacement entries to replacement.xml as you like.

Back to Content