Re: Trigger to Combine Two Columns

Oops... You would actually want to pad those values too probably.

 :new.group = RPAD(:new.group_num,5)||'.'||RPAD(:new.group_name,20)

-Jeff Guttadauro

On Fri, 23 Apr 1999 16:43:11 GMT, shieldsora_at_my-dejanews.com wrote:

>I have a table that has the following fields:
>
>group varchar2(25)primary
>group_num varchar2(5)
>group_name varchar2(20)
>
>I would like to set up a trigger so that the end user only has to enter the
>group_num and group_name and the trigger will combine the two fields seperated
>by a '.' to form the primary key.
>
>Could anyone give me some insight as to how I would formulate a trigger to
>combine these two imputs the way I desire?
>
>Thanks in advance,
>
>Mike
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Apr 23 1999 - 14:16:58 CDT