Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Updating Long Field
Hi:
I need to know how I can compute the results of adding two fields in oracle e.g. given below.
table : Employee emp_address VARCHAR2(2000) emp_resume VARCHAR2(2000) table : temp_emp emp_add_resume LONG;
I need to have a trigger on table Employee which concatenates the emp_address and emp_resume fields and inserts a record into the temp_emp.emp_add_resume field.
Since oracle VARCHAR fields has a limit of 2000 the result of the concatenatation will be greater than the limit. As far as I know PL/SQL variables cannot exceed 2000 characters, I would like to know how this can be done...
Thank you in advance...