Hello,
I'm trying to use a varible as table name to do an insert.
The name of the table where my datas have to be insert is EVV_ + the Ref_var of the data.
My code will be more explicit:
SELECT 'EVV_' || Ref_Equip
INTO v_Ref_Equip
FROM user.c_equip
WHERE clef_equip = v_clef_equip;
INSERT INTO 'user.' || v_Ref_Equip (Clef_var, Date1, Valeur)
VALUES ( v_clef_var, '18/05/01','49,156' );
I don't find the good syntax for the insert into. I've tried many syntax, but not the good one.
So, how can I concatenate 'user.' + my variable v_Ref_Equip ?
Thank for the help