create table (structure) from existing table
- by Domnic
how to create new table which structure should be same as another table
i tried,
Create table dom as select * from dom1 where 1=2
but its not working error occured
In Oracle 10g, I need to update Table A with data from Table B.
Table A has LOCATION, TRANDATE, and STATUS.
Table B has LOCATION, STATUSDATE, and STATUS
I need to update the STATUS column in Table A with the STATUS column from Table B where the STATUSDATE is the max date upto and including the TRANDATE for that LOCATION (basically, I'm getting the…
