Output stream, spooling
Posted: Tue 28 Dec 2021 11:26
I have a set of old queries (from the 1990's) - and to get results user would open an (old) Oracle tool, run multiple queries in one go and then either manually save the output to a file to generate a big report - or using the SPOOL command to output directly to a file.
Eventually I want to break this up and generate a "proper" report.
Meanwhile I need a temporary solution, is there any ODAC component than can achieve this? I did have a look, but not sure what I should be looking for..
A typical and very much simplified, example would be - the main select-from-tables repeated about 10 times for different queries with different result sets:
I assume I can omit the SET and SPOOL commands, but to is there a way to get the content in one text stream?
I have tried a few "workarounds" but there is always something.
Eventually I want to break this up and generate a "proper" report.
Meanwhile I need a temporary solution, is there any ODAC component than can achieve this? I did have a look, but not sure what I should be looking for..
A typical and very much simplified, example would be - the main select-from-tables repeated about 10 times for different queries with different result sets:
Code: Select all
SET FEEDBACK OFF
SET SPACE 1
SET ECHO OFF
SPOOL FILENAME
SET HEADING OFF
SELECT ' ' FROM DUAL;
SELECT 'Section header' FROM DUAL;
SET HEADING ON
SELECT Audkenni, Texti FROM Daemi;
SPOOL OFF
I have tried a few "workarounds" but there is always something.