解决方法
看来你可以用动态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
