lec14.365

lec14.365 - . . Fall 2007 CPE/CSC 365: Introduction to...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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/SQLs 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

Page1 / 2

lec14.365 - . . Fall 2007 CPE/CSC 365: Introduction to...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online