Re: Concatenating and copying columns data

On Mon, 09 Apr 2007 05:38:59 -0700, Usman 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

http://tinyurl.com/36x65w

The URL above points to the Concepts manual. Please read it, practice, buy some of the numerous introductory books and come back when you have invested a polite amount of effort. CDOS != CBT.

-- 
http://www.mladen-gogala.com