I'm using oracle SQL and I need to insert data to multiple users but I need to create insert statements first and replace only user id from the first insert statement as below :
1- This is the insert statement :
INSERT INTO SYS_USER_FUNCTIONS ( USER_ID, FUNCTION_ID_PARENT, FUNCTION_ID_CHILD, A, U,
D, V, R, CREATING_USER, CREATING_DATE, CREATING_TIME, LAST_UPDATE_DATE, LAST_UPDATE_COUNT,
LAST_UPDATE_USER, LAST_UPDATE_TRANSACTION, S )
VALUES ( 'JAD', 'DOCMDOC', 'OPDA100', 1, 1, 2, 1, 2, 'ZYAD', 20210112, 1515, 20210112
, 1, 'ZYAD', 'I', 2);
COMMIT;
2- I need to generate insert statements and replace only `
USER_ID
and select USER_ID from the following table
SELECT USER_ID
FROM USERS
WHERE USER_FUNCTION = 'DOCMDOC'
How can I do that ?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…