Field in Field?
I am sorry if the title is meaningless, as I don't know how to name my problem.
I am using Oracle EBS r12, XML Publisher
put in simply of what I want to achieve:
let said I have a table with 2 columns: (tableA)
name1 | greet1 |
---|---|
Adam | Good Morning, &name1, how are you there? |
David | Welcome to ABC, how are you &name1 ? |
and the SQL in XML data definition is simply:
select name1, greet1 from tableA
and in the RTF template, i have these fields:
<?greet1?>
i test it, and it gives me: (which is not I want)
Good Morning, &name1, how are you there?