Considering account_num has non-numeric fields. to_number going to choke.
Christopher Beck wrote in message
<377d3d43.120536131_at_inet16.us.oracle.com>...
>On Tue, 29 Jun 1999 16:50:27 -0500, Angelica Veron <Faro_at_globalserve.net>
wrote:
>
>>Consider the following 3 fields :
>>
>>HOUSEHOLD_NUM ACCT_NUM_DISPLAY BRAN
>>------------- ----------------
>>----
>>8427400003321 0000000574724777 2827
>>8427400005053 0000000017560888 2827
>>8427400005323 0000000500001670 2827
>>8427400006144 0000000025590888 2807
>>8427400006616 5000575
>>2827
>>8427400007776 0000000AB0045467 2827
>>8427400007776 007800146220002 2827
>>8427400009756 007300062620001 2827
>>8427400009756 0360756
>>2827
>>8427400009756 3812853
>>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.
>
>
>try:
>
>alter table <TABLE_NAME> add service_id number(12);
>/
>
>NOTE
>*** You need to make the service_id field at least
> number(12) to hold the sample data. ***
>
>
>then run
>
>update <TABLE_NAME>
> set service_id = to_number( household_num ) +
> to_number( acct_num_display ) +
> to_number( branch_num )
>/
>
>
>to populate the service_id column.
>
>
>
>
>hope this helps
>
>
>chris.
>
>
>
>--
>Christopher Beck
>Oracle Corporation
>clbeck_at_us.oracle.com
>Reston, VA.
>---------------------------------------------------------------------------
-
>Opinions are mine and do not necessarily reflect those of Oracle
Corporation
Received on Tue Jun 29 1999 - 21:20:23 CDT
