Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about triggers
MAYEKEUL (olivier.debelle_at_gmail.com) wrote:
: Ok ok okokokokokokokokok
: That's right but i tell you before, i'm stupid :)
: So thank you, I see the solution now.
Another technique is a trick using views and instead of triggers.
Create a view similar to the table but with all the fields being varchar2 of some large enough size for what ever data you may be receiving.
Create an instead of insert trigger on the view. Use it to "monitor" the values as they come in. For each column do what ever conversion is appropriate, and then insert the converted values into the real table (do all this within the instead of trigger).
Now to do the conversion you simply insert your raw unconverted data directly into the view.
$0.10 Received on Wed Oct 11 2006 - 20:58:25 CDT