Concatenating and copying columns data

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 Received on Mon Apr 09 2007 - 07:38:59 CDT