您可以将动态SQL与

You could use Dynamic SQL with EXECUTE IMMEDIATE:

CREATE OR REPLACE
PROCEDURE p
AS
BEGIN
   EXECUTE IMMEDIATE 'CREATE TEMPORARY TABLE A(id NUMBER)...etc';
END p;

显然，您必须确保EXECUTE IMMEDIATE语句中的语法正确.

Obviously you'll have to ensure your syntax is correct within the EXECUTE IMMEDIATE statement.

希望有帮助.