When wanting to combine text you can use the concatenation operator
Examples:
To place comma after every row returned use as follows:
SELECT table_name ',' FROM user_tables;
You may have a date that you wish to place in a CSV file, you can concentate as follows:
SELECT 'the date today is: ' to_char(sysdate, 'MM-DD-YYYY') ',' FROM sys.dual;
