declare
p_table varchar2(255):='DATENBANK';
p_col varchar(255);
p_num varchar(255);
p_type varchar2(255):='varchar2(255)';

begin
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM user_tab_columns WHERE table_name = ''DATENBANK''' into p_num;
p_col:= CONCAT('t',p_num);
EXECUTE IMMEDIATE 'ALTER TABLE ' || p_table || ' add (' || p_col || ' ' || p_type || ')';
end;



1 mal bearbeitet. Zuletzt am .