sql - How do I write stored procedures to update one table of one schema from another table of a different schema? -

i made mistake of updating table, data should of not of. tried flashback, table seem large, flashback statement. think might able take data dev server production server. created user schema on production server , imported data need sort of fix update mistake. there thousands of rows, affected.

can me on how update table data 1 schema table in different schema, on same database. want write stored procedure , loop on through , update. sort of have idea, , been googling it. don't know how call or differentiate table names in different schemas inside stored procedure.

thank

if understanding question correctly, asking how write query different schemas.

all need prefix table name schema name.

example schema: cat , schema dog

select * cat.food cf join dog.food df on cf.sustinanceid = df.sustinanceid 

the same concept applies insert or update. prefix schema name.