Hi
I have a test_table (col1, col2, col3) on apex.oracle.com.
Firstly:
I would like to create report as type SQL Query:
select col1, col2, col3 from test_table;
I would like to change properties of col2 eg font or color during generation.
In source of report I must write code (it is only example ???):
select col1,
'<span style="font-weight:bold;">' col2 '</span>',
col3
from test_table;
I think it is wrong but I would like to know what are the first principles of linking sql and html.
Secondly:
I create report as type PLSQL function body returning SQL query:
begin
return 'select col1, '
|| ''<span style="font-weight:bold;">''|| 'col2 '||'</span>',
||'col3
from test_table;';
end;
What is wrong in both examples? I can't find it in documentation. Could you tell me something about principles.
Regards
Ziut