看来你可以用动态SQL做到这一点:
begin
execute immediate 'create user ":MY_SCHEMA" identified by xxx';
end;
/
PL/SQL procedure successfully completed.
select username, account_status from dba_users where username = ':MY_SCHEMA';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
:MY_SCHEMA OPEN
begin
execute immediate 'drop user ":MY_SCHEMA"';
end;
/
PL/SQL procedure successfully completed.
select username, account_status from dba_users where username = ':MY_SCHEMA';
no rows selected