how to insert the data in 2 tables in pl/sql stored procedure?
i have 2 tables table1, table2 . table1 columns are id,empname and table2 columns are id,empname, location.. so first insert the data in table1 based on table1 columns id, empname insert the data in table2.. that means table2 id,empname columns data must be same to table1 columns...if insert unmatched data it has to through error example
table1 table2
id empname id empname location
10 raju 10 raju hyd
20 kumar 20 kumar kerala
50 anil 50 anil TN
will no insert like that table2
id empname location
20 raju hyd
11 kumar kerala
here if try to enter that type of data it has to show error
i want script in pl/sql stored procedure
please help me urgent......