Using DBMS Packages
System packages can be used in user packages as long as the user has permissions. SQL Server has several system procedures and extended procedures that are used in the same way as the Oracle packages.
We have already looked at DBMS_SCHEDULER and DBMS_STATS in previous chapters. The following are a few other packages you might consider using:
DBMS_OUTPUT is useful for seeing what is running in a stored procedure. It sends output to the screen.
DBMS_METADATA is useful for getting the definitions of the objects.
DBMS_REDEFINITION ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
