How to I interleave logs from two different Oracle tables?
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.