Selects data into an Excel Formula instead of as an excel value.
This way data from the database can be regarded as formulae as well.
You can use it to automatically wrap the data up in an Excel formula.
Example: select ename, 'dollar('||to_char(sal)||chr(44)||'2)' as formula from emp;
This would create the salary field formatted as accounting using the Excel dollar
function (note this formats the number according to your regional settings and
not only as USD...).
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.