Packages Related to Input/Output

Contact Us or call 1-877-932-8228
Packages Related to Input/Output

Packages Related to Input/Output

There are a number of ways to get data into and out of the database. Using SQL, you can retrieve data using SELECT statements and add new data using INSERT statements. As seen throughout the course, the DBMS_OUTPUT provides a mechanism for returning buffers of data. These have been displayed to the screen using the PUT_LINE procedure. The DISABLE procedure can be used to disable DBMS_OUTPUT so that output is not displayed. The ENABLE procedure can be used to enable DBMS_OUTPUT and set the buffer size. You can control buffer retrieval using the GET_LINE and GET_LINES procedures.

BEGIN dbms_output.enable(1000000); dbms_output.put_line('You have seen this before...'); END;

Another package related to both input and output is the UTL_FILE package. This package allows you to read and write files on the database server. Note, this package does not allow you to read files where the database client resides (unless the client is the database server itself). The use of this package involves interaction with the underlying operating system. Therefore additional configuration is required including the creation of Oracle Directory objects and the granting of appropriate permissions.

Next