![]() ![]() Retrieves an array of lines from the buffer. Retrieves a single line of buffered information.ĭBMS_OUTPUT.GET_LINES (lines OUT CHARARR, numlines IN OUT INTEGER) A NULL value of buffer_size represents unlimited buffer size.ĭBMS_OUTPUT.GET_LINE (line OUT VARCHAR2, status OUT INTEGER) The DBMS_OUTPUT package has the following subprograms − S.NoĭBMS_OUTPUT.ENABLE(buffer_size IN INTEGER DEFAULT 20000) Įnables message output. Try it in your database to list down all the table names −ĭbms_output.put_line (user || ' Tables in the database:') įOR t IN (SELECT table_name FROM user_tables) Let us look at a small code snippet that will display all the user tables in the database. We have already used this package throughout our tutorial. The DBMS_OUTPUT is a built-in package that enables you to display output, debugging information, and send messages from PL/SQL blocks, subprograms, packages, and triggers. In this chapter, we will discuss the DBMS Output in PL/SQL. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |