Sorry for not enough information. I mean that, I have a tableTAB, a varchar2 field, its name: DESCRIPTION , data in this field is stored as following: [some_space][some_numbers][some_spaces][some_characters]
And other column MONEY (number(10))
I wrote a function NOSPACE that delete all space in the data that I get from DESCRIPTION field. It’s ok.
Now I want to write an after insert or update trigger that insert just the [some_numbers] into another field in the same table.
For example: the data in DESCRIPT column is ‘ 200.000 good well better’
So all that I want my trigger to get 200.000 to insert into MONEY column after inserting or updating on my table TAB. (I use Ora9i R2)
Please help me this problem, thanks very much