SQL query result is an SQL statement, how to implement this statement-CodePudding

CodePudding user response:

 begin 
For cur in (select 'select 1 from dual aa from dual connect by level & lt; 5) loop 
The execute immediate cur. Aa; 
end loop; 
end;

But you are executing a select statement is going to do

CodePudding user response:

reference 1st floor nayi_224 response:

 begin 
For cur in (select 'select 1 from dual aa from dual connect by level & lt; 5) loop 
The execute immediate cur. Aa; 
end loop; 
end;

But you are executing a select statement to why

Because behind in a select statement can't write?