I am creating some flat files extracting some data from Oracle using toad, however I would like to put in a header and a footer. Is there a way to add a header row and a footer row to your output ?
Example of the format of SQL i'm using below:
SELECT
''''field1''''||''''field2''''||''''field3'''' as flat_file
FROM
foo
ORDER Y
field1
Example of the format of SQL i'm using below:
SELECT
''''field1''''||''''field2''''||''''field3'''' as flat_file
FROM
foo
ORDER Y
field1
Comment