create or replace trigger admin
                  after insert on admin
                  for each row
                  declare
                   bang varchar2(250):='ADMIN';  
                   tam varchar2(250);
                   tam1 varchar2(250);
                   cursor cs1 is Select COLUMN_NAME from user_tab_columns where table_name=bang;
                  
                begin
                    for i in cs1
                    loop

                         tam:=':new.'||i.column_name'; --such as :new.username,:new.password ....
                         -- but i query [b] select tam from dual[/b] ,it just show a string [b]:new.username[/b] not result (such as admin....)
                     -- select :new.i.column_name from dual but not run
                         select tam into tam1 from dual;
                                            
                    end loop;
                      
                  end;

declare
    cursor cs is select table_name from user_tables;
begin
    for i in cs
    loop    
    
      execute immediate '
                
                  create or replace trigger '||i.table_name||'
                  after insert on '||i.table_name||'
                  for each row
                  ...................

mr value
1   3625242
2   6454
3   36353