Re: Question about triggers

OK
I'm just do that and it's work prefectly

thank you for your help

Mayekeul

Malcolm Dew-Jones a écrit :

> 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 Tue Oct 17 2006 - 08:15:58 CDT