(SQL) User tables are separated into two sections

Arun,

now that sqlcl is available fromOracle SQL Developer 4.1 EA2 (4.1.0.18.37) you can use it a lot like the old and famous sqlplus. sqlcl has an output format setting for csv

set sqlformat csv
spool x.csv
select * from yourtable[s];
spool off

for more info about sqlcl checkout Kris' blog

before sqlcl was around easiest for this was to use APEX and export the report to csv. In plain old sqlplus you can do this by using

set lines 9999 -- the appropriate size
set head off  -- no header lines
set colsep ';' --column separator to ;
set pages 0 -- no pages
set feed off
select your data;
spool to_tofile
/
spool off

This works best if the results are to be written on an application server or client. If they have to be written on the database server, utl_file might be a better option.

Ronald.

select 'LOG_1' AS LOG_SOURCE, TIME_CREATED,ENTRY_TEXT FROM LOG_1

UNION ALL

select 'LOG_2', TIME_CREATED,ENTRY_TEXT FROM LOG_2

ORDER BY 2

I formalize this kind of logic as a view so you can document and comment it.

CREATE OR REPLACE FORCE VIEW COMBINED_LOGS

(LOG_SOURCE,

TIME_CREATED,

ENTRY_TEXT ) AS

select 'LOG_1' , TIME_CREATED,ENTRY_TEXT FROM LOG_1

UNION ALL

select 'LOG_2', TIME_CREATED,ENTRY_TEXT FROM LOG_2;

COMMENT ON TABLE COMBINED_LOGS IS 'Explanatory comment goes here';

This works for me on Oracle 11g R2 and Oracle 9i, perhaps it was the use of keyword SOURCE as a column name which I have corrected to LOG_SOURCE

Edit: Corrected to UNION all after the comment. See here for more discussion on the details of UNIONS. This should be done for performance reasons and to ensure identical records are not removed.