Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Wednesday, 27 September 2017

How to Use Oracle SQL Functions in BI/XML Publisher Reports



XML Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is

for extended SQL functions <?xdofx:expression?>

for extended XSL functions<?xdoxslt:expression?>

Example of Extended SQL Functions

<?xdofx:decode(’xxx’,’bbb’,’ccc’,’xxx’,’ddd’)?>
<?xdofx:Instr(’abcabcabc’,’a’,2)?>
<?xdofx:substr(’abcdefg’,2,3)?>
<?xdofx:to_number(’12345’)?>
<?xdofx:replace(name,’John’,’Jon’)?>


Share this article :

0 comments:

Post a Comment