Oracle Doubt Please Help
- Hi friends,
I've some doubts about records. It is as follows.
I created a record and inserted values into it using the
1. type temp_table_rec is record ( name Varchar2(20),
type temp_table_tbl is table of temp_table_rec index by
2. Open cursor temp_table_cur for select
last_name,employee_id,salary from employees;
FETCH temp_table_cur INTO l_temp_table(v_count);
v_count := v_count+1;
EXIT WHEN temp_table_cur%NOTFOUND;
Now The temp_table_rec contains arround 107 raws.
My problem is as follows,
a) I've to update a particular raw of the record.(I've to update
the name to 'Smith' if the id=145).
b) I've to delete a particular raw of the record.
c) Is it possible to insert the values of this record into a table
without using loop?
Please help me to solve these
Thanks in advance and regards,