In this article, we will examine the DBMS_OUTPUT package in some detail. DBMS_OUTPUT package in Oracle, like other DBMS packages, is owned by the Oracle user SYS.
The script which creates DBMS_OUTPUT grants the EXECUTE permission on the package to the PUBLIC, and creates a public synonym for it. This means that any Oracle user can call the routines in DBMS_OUTPUT without having to prefix the package name with SYS.
from DZone.com Feed https://ift.tt/3jVSh4m
No comments:
Post a Comment