Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Concatenating and copying columns data
On Apr 9, 8:38 am, "Usman" <khanus..._at_gmail.com> wrote:
> Hi,
>
> I am a newbee to Oracle SQL programming. I have a problem where I have
> three columns, A - varchar, B-varchar and C-numeric
>
> Column A can contain alphanumeric character.
> Column B will always contain numeric characters.
>
> I need to write a trigger that will on every row inserted,
>
> 1. Check if column A exists then,
> 2. If 1 is true, convert each alphabet in column A to its equivalent
> ASCII and leave the numeric characters as it is. Therefore, for
> example if I have 'A567', I should have 67567 as an end result,
> assuming ascii code of 'A' is 67.
> 3. Concatenate converted string in 2 above with data inserted in
> column B.
> 4. Convert to number/long in 3 above and store the data in column C.
>
> Example:
>
> column A = 'A567'
> column B= '1234'
> column C = 675671234
>
> Can anyone please help me implementing this logic?
>
> Any help in this regard will be appreciated.
>
> Thanks in anticipation,
> Usman
Sounds like homework to me.
If this is a real world work related problem please supply business requirements for this trigger. Received on Mon Apr 09 2007 - 08:16:20 CDT