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 -> Trigger to Combine Two Columns

Trigger to Combine Two Columns

From: <shieldsora_at_my-dejanews.com>
Date: Fri, 23 Apr 1999 16:43:11 GMT
Message-ID: <7fq7uu$4u5$1@nnrp1.dejanews.com>


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 - 11:43:11 CDT

Original text of this message

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