Introduction to Oracle built-in subroutines

Introduction to Oracle built-in subroutines SQL> set serveroutput on; SQL> remark built-in package SQL> common built-in packages of remark are as follows: SQL> Input and Output in remark DBMS_OUT PL/SQL display SQL> remark DBMS_JOB Task Scheduling Service SQL> remark DBMS_LOG large object operation SQL> remark DBMS_PIPE database pipeline, allow inter-session communication SQL> remark DBMS_ SQL dynamic SQL> remark UTL_FILE text file input and output; SQL> the corresponding remark package contains some stored procedures: SQL> remark put and put_line: put the data in the output buffer. put_line also outputs line breaks. SQL> remark new_line: adds a line break to the buffer, indicating the end of a line. SQ L> remark get_line: returns a string; SQL> remark ename disable used to control the buffer size SQL> dbms_output.get_line (); SP2-0734: unknown command beginning "dbms_outpu... "-rest of line ignored. SQL> dbms_output.put_line ('dd'); SP2-0734: unknown command beginning "dbms_outpu... "-rest of line ignored. SQL> remark example: Call the Stored procedure SQL> execute dbms_output.put_line ('test') in the corresponding package; test PL/SQL procedure successfully completed. SQL> r Emark DBMS_LOB LOB -- Large Objects-Large object: a data type (4 GB) used to store a Large amount of binary and text data. SQL> remark is currently divided into two types: internal LOB and external LOB, internal LOB stores data in the database as byte streams. Therefore, many internal LOB operations can be involved in transactions, or they can be backed up and restored just like normal data. SQL> remark common LOB processes: the SQL> remark DBMS_LOB package mainly provides several processes for users to maintain internal LOB fields. SQL> remark APPEND (); Add the content in the source LOB to the target lob SQL> spool off; the DBMS_RANDOM package is a package for obtaining random numbers, this package provides a function to obtain random numbers and random characters. The function is as follows: initialize (seed in binary_integer) sets the seed of the random number generator, and re-initializes seed (val in binary_integer ); set the seed normal return number for random number generation to return a random number string (opt in char, len in number); return a random string;