title: Last 24 hours updated records from table using Oracle SQL?
body: <p>I have a Pl/SQL query that pull all records from the 3 tables. That is good. Now I want pull last 24 updated records from 2 table (tbl_constit, tbl_email).</p>
  
  <p>See below actual query</p>
  
  <pre><code>SELECT DISTINCT c.constit_id AS constitid,
                 REPLACE (c.in_labelname, 'None', '') AS fullname,
                 c.firstname AS firstname, c.lastname AS lastname,
                 c.indiv_title AS title, e.e_addr AS email,
                'InActive' AS status                               
            FROM tbl_constit cn, tbl_email e,tbl_catcod s
           WHERE c.constit_id = e.constit_id
             AND c.constit_id = s.constit_id(+)
             AND e.e_type = 'EMAIL'
             AND e.e_default = '1'
             AND s.cat_code IN ('SPEMU', 'SPENM')              
        ORDER BY c.constit_id;
  </code></pre>
  
  <p>tables tbl_constit cn, tbl_email e has 'CHGD_DT' field. </p>
  
  <p>This date field change when record is updated. <strong>Now How can I pull last 24 updated records from tbl_constit cn or tbl_email by using 'CHGD_DT' field?</strong> </p>
  
  <p>Change can happen any one of two tables.</p>