Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Concatenating and copying columns data
"Usman" <khanusman_at_gmail.com> a écrit dans le message de news: 1176122999.684062.253210_at_p77g2000hsh.googlegroups.com...
| 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
|
Do your homework.
Post what you've done if you are stuck.
We help you to go on.
Regards
Michel Cadot
Received on Mon Apr 09 2007 - 08:15:04 CDT