ACS3 Data Model

     1: procedure ad_drop_column ( p_table_name IN varchar, p_column_name IN varchar )
     2: IS
     3: 	v_exists_p	number;
     4: BEGIN
     5: 	select decode(count(*),0,0,1) into v_exists_p
     6:           from user_tab_columns
     7:          where TABLE_NAME = upper(p_table_name)
     8:            and COLUMN_NAME = upper(p_column_name);
     9: 
    10: 	IF v_exists_p = 1 THEN
    11: 		EXECUTE IMMEDIATE 'alter table ' || p_table_name || ' drop column ' || p_column_name;
    12:  	END IF;
    13: END;