Tuesday, September 8, 2015

Delete Custom Table Registration

--
BEGIN
/*
   AD_DD.DELETE_COLUMN('XXAK'
                                                  , 'XXAK_WEB_ADI_DOWNLAOD_TBL'
                                                 ,'ORDER_NUMBER'
                                                    );
*/
   AD_DD.DELETE_TABLE('XXAK' -- Application short Name
                                             ,'XXAK_WEB_ADI_DOWNLAOD_TBL'  -- Table Name
                                              );
 
   COMMIT;
 
   dbms_output.put_line('Deleted :');



EXCEPTION
   WHEN OTHERS THEN
      dbms_output.put_line('Error :'||sqlerrm);
      ROLLBACK;
END;
--


Related Post: Register Custom Table

No comments:

Post a Comment