Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Updating Long Field

Updating Long Field

From: Terry Heung-Man Lam <tlam_at_cs.umd.edu>
Date: 1997/06/22
Message-ID: <5okg4e$74e@snickers.cs.umd.edu>#1/1

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...

Received on Sun Jun 22 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US