Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE A (
SEQ_NO        NUMBER(6),
CONTENT       VARCHAR2(20) 
);
CREATE TABLE B (
STMT_1       VARCHAR2(20),
STMT_2       VARCHAR2(20),
STMT_3       VARCHAR2(20),
STMT_4       VARCHAR2(20)
);
INSERT INTO B VALUES (NULL, NULL, NULL, NULL);
1 rows affected

create or replace trigger TestTrig
  after insert on A
  for each row
DECLARE
  temp varchar2(11);
begin
  temp := 'Stmt_' || TO_CHAR(:new.seq_no, 'FM999990');
  EXECUTE IMMEDIATE 'UPDATE B SET ' || temp || ' = :1' USING :NEW.content;
end;
/
INSERT INTO a (seq_no, content) VALUES (1, 'This is the content');
1 rows affected

INSERT INTO a (seq_no, content) VALUES (5, 'This is also content');
ORA-00904: "STMT_5": invalid identifier
ORA-06512: at "FIDDLE_QOHLKINGUCDIKMZJJAYP.TESTTRIG", line 5
ORA-04088: error during execution of trigger 'FIDDLE_QOHLKINGUCDIKMZJJAYP.TESTTRIG'

SELECT * FROM A;


SEQ_NO
CONTENT


1
This is the content


create or replace trigger TestTrig
  after insert on A
  for each row
DECLARE
  temp varchar2(11);
  INVALID_IDENTIFIER EXCEPTION;
  PRAGMA EXCEPTION_INIT(INVALID_IDENTIFIER, -904);
begin
  temp := 'Stmt_' || TO_CHAR(:new.seq_no, 'FM999990');
  EXECUTE IMMEDIATE 'UPDATE B SET ' || temp || ' = :1' USING :NEW.content;
EXCEPTION
  WHEN INVALID_IDENTIFIER THEN
    NULL;
end;
/
INSERT INTO a (seq_no, content) VALUES (5, 'This is also content');
1 rows affected

SELECT * FROM A;


SEQ_NO
CONTENT


1
This is the content

5
This is also content


SELECT * FROM B;


STMT_1
STMT_2
STMT_3
STMT_4


This is the content
null
null
null


DROP TRIGGER testtrig;
DROP TABLE B;
CREATE VIEW B (stmt_1, stmt2, stmt3, stmt4) AS
SELECT *
FROM   A
PIVOT (
  MAX(content)
  FOR seq_no IN (
    1 AS stmt_1,
    2 AS stmt_2,
    3 AS stmt_3,
    4 AS stmt_4
  )
);
SELECT * FROM B;


STMT_1
STMT2
STMT3
STMT4


This is the content
null
null
null