This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: . . Fall 2007 CPE/CSC 365: Introduction to Database Systems Alexander Dekhtyar . . PL/SQL: Built-in I/O package Built-in Packages Some of the PL/SQL functionality is provided in a form built-in libraries or packages of functions and procedures. A brief list of PL/SQL’s built-in packages is below: dbms output package: provides functionality for I/O operations. dbms sql package: provides ability to execute dynamically created SQL state- ments (including relational schema alterations). htp package: HTTP and HTML-related procedures. dbms output package dbms output package includes procedures and functions necessary for I/O op- erations. i/o buffer: dbms output package works with an i/o buffer. The put procedures add content to the buffer, the get procedures retrieve content from the buffer. Enabling buffer output. This can be done in two ways. • SQL*plus. In sql*plus type SQL> set serveroutput on to enable the output with the default buffer size of 2000. To change buffer size, use SQL>set serveroutput on size <value>...
View Full Document
- Spring '08
- Databases, dbms output package