plsql - 具有 into 关键字的动态 SQL Select 语句

Question

我有一个存储过程，它创建表并动态插入到该表中，这里一切正常。以下代码的问题

execute immediate
'SELECT NAME 
INTO variable1
FROM table1 
WHERE ID = 2';

错误是:缺少关键字。

Answer 1

execute immediate
  'SELECT NAME FROM table1 WHERE ID = 2'
  into variable1;