Oracle trigger (insert multiple rows into table)
Posted on 2014-11-13
I have a trigger in Oracle database. It select a single record from one table and insert into another table. Now the select might return more than 1 record. Please suggest.
//Below is the code it select a record from table
select phone into pp_nextel_phone
pp_nextel_phone := null;
//below is the code I insert into another table
insert into mssg_log(PHONE,mssg_type,PCODE,PHSDSC,extra_dsc)