Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can You Convert a Field ?
Hi,
I'm afraid you are to general
You want add new field to exisiting table, or
create a hash fielf which is cobined of this three ??
Can you explain ?
Regards,
Adam
Angelica Veron napisał(a) w wiadomości:
<37794094.2FAC1E67_at_globalserve.net>...
>Consider the following 3 fields :
>
>HOUSEHOLD_NUM ACCT_NUM_DISPLAY BRAN
>------------- ----------------
>----
>8427400003321 0000000574724777 2827
> These 3 fields are
>
> Name Null? Type
> ------------------------------- -------- ----
> HOUSEHOLD_NUM NOT NULL VARCHAR2(13)
> ACCT_NUM_DISPLAY NOT NULL VARCHAR2(16)
> BRANCH_NUM NOT NULL CHAR(4)
>
>
> I need to combine the total of each 3 given fields as a new field of
>type NUMBER(10), called Service_id . So service_id would be a new 4th
>field (numerical) which has the total of Household_NUM, ACCT_NUM_DISPLAY
>and BRANCH_NUM, how do I do that ??.... how do I create a new field
>called Service_id in the above table ?. Can anyone help ?? I would be
>realy grateful for any help, thank you so much for your time.
>
>
Received on Tue Jun 29 1999 - 17:07:52 CDT