Re: Autopopulation by concatenation

Coburn -

I must be missing something here. Why can't you do

insert into emp values (field1,field2,field1||field2) ?

There will be an implicit conversion to char, btw, so make sure field 3 is of the varchar2 datatype.

hth -

Regards,
jh

Coburn Watson <cpw_at_slip.net> wrote:

>I have a relatively basic table which, when insertions are made, I would
>like the last field (trackid) to be generated by concatenating the
>values of the first two fields (num1 & place1). For example, if I
>insert a row into this table with the data (num1, place1)values (4,
>paris), then I would like my trackid field to be "4paris". I attempted
>to perform this action with an AFTER INSERT trigger, but I get the
>"mutating" table error. I take this is since the data which the trigger
>is relying on has just been inserted and is unavaible for selection
>(?!?). Any help would be appreciated.
>
>Coburn Watson
>Information Systems Support - Research
>Scios, Inc.
>cpw_at_slip.net

Jared Hecker, CODBA       | Oracle  and Sybase Architect and DBA
jared_at_planet.net          | - consulting in the 
76276.740_at_compuserve.com  |   NYC/NJ region - available now!