Create trigger - build SQL statement and execute it
I know I am likely over thinking this!
I want an on insert trigger on a table "employee". Also open to other options as well.
when a new record is inserted into the employee, I want to generate a script , and run it. This will create a user in our APEX system.
I can run it on the command line and manually execute it in a sql script no problem. Trying to automate it so I don't have to create a user each time a new user is onboarded.
Trying to figure out how to do the same thing but in a trigger - when a new record is inserted, build and execute the command.