DECLARE
 x	varchar2(100); 
BEGIN
  x := 'ALTER  TABLE CALL_DETAIL_0109 add col10 varchar2(15)';
  EXECUTE IMMEDIATE x;
END;
/

DECLARE
 v_tab		  varchar2(100);
 x		  varchar2(100); 
 CURSOR call_details_rows IS 
 SELECT TNAME from tab 
 where tname like 'CALL_DETAIL_____';
BEGIN
  OPEN call_details_rows;
    LOOP
  	  FETCH call_details_rows 
  	  INTO v_tab;
  	  EXIT WHEN call_details_rows%NOTFOUND;
  	  x := 'ALTER  TABLE '||v_tab||' add col6 varchar2(15)';
  	  EXECUTE IMMEDIATE x;
    END LOOP;
   CLOSE call_details_rows;
END;
/