Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can You Convert a Field ?

Re: Can You Convert a Field ?

From: Adam Danieluk <adanielu_at_natned.com.pl>
Date: Wed, 30 Jun 1999 00:07:52 +0200
Message-ID: <7lbfni$lie$1@sunsite.icm.edu.pl>


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

Original text of this message

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