您可以创建存储过程以在PL/SQL中执行此操作，方法是将SQL语句动态创建为字符串，然后使用execute immediate执行它并返回光标.

You could create a stored procedure to do this in PL/SQL by dynamically creating your SQL statement as a string an then using execute immediate to execute it and return a cursor.