Help

declare
i number:=1;
dy_sql varchar(100);
begin
dy_sql:='alter table tb_exam add d'||:a||' number';
execute immediate dy_sql using i;
end;
This statement has the problem how to do ah!!!

Started by Baron at November 26, 2016 - 11:50 AM

This in the database there is good. Debugging see dy_sql value.

Posted by Jean at November 28, 2016 - 12:07 PM

Like stored procedures.

Posted by Frances at December 06, 2016 - 12:11 PM

pl/SQL cannot read

Posted by Albert at December 07, 2016 - 12:44 PM

The stored procedure. I went to I can not move!

Posted by Colin at December 14, 2016 - 1:26 PM

dy_sql:='alter table tb_exam add d'||:a||' number';
execute immediate dy_sql using i;

This style of writing has problems.

Posted by Cloris at December 24, 2016 - 2:25 PM

The following written on it.
declare
i number:=1;
dy_sql varchar(100);
begin
dy_sql:='alter table ax add d'||i||' number';
execute immediate dy_sql;
end;

Posted by Cloris at January 04, 2017 - 3:04 PM

+1

Posted by Dennis at January 09, 2017 - 3:36 PM

The response to 2013-10-24 15:41:10 was removed by the administrator

Posted by Crystal at January 12, 2017 - 4:29 PM