Oracle - Query inside query

Question

我想要在oracle中创建用户，使用我现有的表名为EMPLOYEE，我想要生成一个查询来创建具有用户名的用户。用户名在EMPLOYEE表中。

我想像下面这样创建一个查询

CREATE USER (SELECT first_name FROM employee where employee_id = '1') 
IDENTIFIED BY password .....so on

Answer 1

DBMS_UTILITY.EXEC_DDL_STATEMENT可用于在PLSQL中运行DDL语句，因此您可以尝试执行以下操作

BEGIN
FOR c IN (select 'CREATE USER  ' || first_name || ' ' || 'IDENTIFIED BY ' ||
                 password_column ||' ' as rec
            from employee where employee_id=1) LOOP
  begin
    dbms_utility.exec_ddl_statement(c.rec);
  exception
    when others then
      dbms_output.enable;
dbms_output.put_line  ('failed for '||c.rec);
dbms_output.put_line(sqlerrm);
    end;
  END LOOP;
  END;