<div>
there were 2 identical solutions posted within seconds of each other, &nbsp;a split is appropriate
</div>


there were 2 identical solutions posted within seconds of each other,  a split is appropriate

<div>
<div class="content wysiwyg-content">
select rh.rec_hdr_id hdr_id,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; rd.rec_hdr_id dtl_id,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;rh.po_number,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; rh.date_received,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; rh.create_time hdr_time,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; rd.create_time dtl_time, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; rh.audit_key,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;rd.rec_det_id, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; rd.item_code<br />
&nbsp; from receiver_header rh,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; receiver_detail rd<br />
&nbsp;where rh.rec_hdr_id = rd.rec_hdr_id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
--------------------------<wbr />--<br />
I need to update the create_time of the receiver_detail with create_time of the receiver_header table.
</div>
</div>


select rh.rec_hdr_id hdr_id,
	   rd.rec_hdr_id dtl_id,
                   rh.po_number,
	   rh.date_received,
	   rh.create_time hdr_time,
	   rd.create_time dtl_time, 
	   rh.audit_key,
                   rd.rec_det_id, 
	   rd.item_code
  from receiver_header rh,
          receiver_detail rd
 where rh.rec_hdr_id = rd.rec_hdr_id	
----------------------------
I need to update the create_time of the receiver_detail with create_time of the receiver_header table.

updating oracle table

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.