Advanced usage of Macros

[a-s-z]

Hello,

how do I use macros in a query without sticking to word boundaries?

I want to use a macro M_TAB=ATable and want to assemble column names by using the macro, i.e.

Code: Select all

select &(M_TAB)_ID ID, text from &M_TAB

should result in

Code: Select all

select ATable_ID ID, text from ATable

Currently the usage of brackets (or something similar) around the macro name does not seem to be possible

[Plash]

Currently it is not possible.

We will investigate the possibility of implementing this feature.

[jfudickar]

I would suggest to use the oracle mimic, stopping at the first ".".

In the syntax should be

Code: Select all

select &M_TAB._ID ID, text from &M_TAB 

Kind regards
Jens