Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE TABLE_2(EMP_ID VARCHAR2(10),VALUE VARCHAR2(10))
INSERT ALL 
  INTO TABLE_2(EMP_ID,VALUE) VALUES (EMP_ID, 'Rick')
  INTO TABLE_2(EMP_ID,VALUE) VALUES (EMP_ID, 'Tom')
  INTO TABLE_2(EMP_ID,VALUE) VALUES (EMP_ID, 'Adam')
SELECT '111' AS EMP_ID,'COL1' COLUMN_NAME FROM DUAL;
3 rows affected

SELECT * FROM TABLE_2;


EMP_ID
VALUE


111
Rick

111
Tom

111
Adam