ramesh

ramesh

  • NA
  • 19
  • 46.9k

how to insert the data in 2 tables in pl/sql stored procedure?

Aug 23 2012 12:52 AM
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......

Answers (5)