ORACLE TRIGGER INSERT INTO ... (SELECT * ...)

Question

Trigger with Insert into (select * ...)

I'm trying it.

INSERT INTO T_ USERS SELECT * FROM USERS WHERE ID = :new.ID;

not working...

this work.

INSERT INTO T_USERS(ID) VALUES(:new.ID);

Trigger

create or replace trigger "TRI_USER"
AFTER
insert on "USER"
for each row
begin
INSERT INTO T_USER SELECT * FROM USER WHERE ID = :new.ID;
end;​

Answer 1

this work.

INSERT INTO T_USERS(ID) VALUES(:new.ID);

So if it fits to you then try this:

INSERT INTO T_USER(ID) SELECT ID FROM USER WHERE ID = :new.ID;

If you want to select one or more rows from another table, you have to use this syntax:

insert into <table>(<col1>,<col2>,...,<coln>)
select <col1>,<col2>,...,<coln>
from ...;