karlapalem vamsidhar

karlapalem vamsidhar

  • 2.1k
  • 65
  • 2.7k

Need to update Table columns using View in Oracle

May 13 2021 1:19 PM
Hi All,
 
I Need to update the columns values of Table FIRETABLE with the View FCAM_SITES_V with inner join of other tables 
But not able to do it, Kindly please suggest what wrong with the below query? I am getting Errro in the FROM
 
Please provide your solutions asap. Correct the Query as well
 
Update Query: 
  1. Update FIRETABLE SET  
  2. FFM.TECHNICAL_SQUARE_FEET = FSV.TECHNICAL_SQUARE_FEET,  
  3. FFM.COMMON_SQUARE_FEET = FSV.COMMON_SQUARE_FEET ,  
  4. FFM.ROOF_REPAIRED_DATE = FSV.ROOF_REPAIRED_DATE,  
  5. FFM.RAISED_FLOOR = FSV.RAISED_FLOOR,  
  6. FFM.YEAR_BUILT = FSV.YEAR_BUILT,  
  7. FFM.NUMBER_OF_BUILDINGS = FSV.NUMBER_OF_BUILDINGS,  
  8. FFM.OCCUPIED_FLOORS = FSV.OCCUPIED_FLOORS  
  9. FROM  
  10. FIRETABLE FFM  
  11. INNER JOIN  
  12. SITES_MAPPING FSM  
  13. ON FFM.FACILITY_ID = FSM.FACILITY_ID  
  14. INNER JOIN  
  15. FCAM_SITES_V FSV  
  16. ON FSV.SITEID=FSM.FACILITY_SITE_ID;  
  17. COMMIT; 

Answers (1)