关于dbms_output包的使用
General | ||||||||||
Source | {ORACLE_HOME}/rdbms/admin/dbmsotpt.sql | |||||||||
First Available | 7.3.4 | |||||||||
Data Types | TYPE chararr IS TABLE OF VARCHAR2(32767) INDEX BY BINARY_INTEGER; -- Note: was 255 bytes in 10gR1 and earlier TYPE dbmsoutput_linesarray IS |
|||||||||
Dependencies | SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_OUTPUT' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_OUTPUT'; |
|||||||||
Exceptions |
|
|||||||||
SQL*Plus | SET SERVEROUTPUT ON in SQL*Plus is equivalent to:
dbms_output.enable(buffer_size => NULL); |
|||||||||
DISABLE | ||||||||||
Disable DBMS_OUTPUT and reset the buffer size to the default | dbms_output.disable; | |||||||||
exec dbms_output.disable; | ||||||||||
ENABLE | ||||||||||
Enable DBMS_OUTPUT and set the buffer size. The buffer size can be between 1 and 1,000,000 | dbms_output.enable(buffer_size IN INTEGER DEFAULT 20000); | |||||||||
exec dbms_output.enable(1000000); | ||||||||||
GET_LINE | ||||||||||
Returns a single line of buffered information | dbms_output.get_line(line OUT VARCHAR2, status OUT INTEGER); | |||||||||
set serveroutput on
DECLARE |
||||||||||
GET_LINES | ||||||||||
Retrieves an array of lines from the buffer
Overload 1 |
dbms_output.get_lines(lines OUT CHARARR, numlines IN OUT INTEGER); | |||||||||
set serveroutput on DECLARE outtab dbms_output.chararr; fetchln INTEGER := 15; BEGIN outtab(1) := 'This is a test'; outtab(12) := 'of dbms_output.get_lines'; dbms_output.put_line('A: ' || outtab(1)); dbms_output.get_lines(outtab, fetchln); dbms_output.put_line('A: ' || outtab(1)); dbms_output.get_lines(outtab, fetchln); FOR i IN 1 .. fetchln LOOP |
||||||||||
Overload 2 | dbms_output.get_lines( lines OUT dbmsoutput_linesarray, numlines IN OUT INTEGER); |
|||||||||
set serveroutput on
BEGIN dbms_output.get_lines(lo, fetchln); dbms_output.get_lines(lo, fetchln); FOR i IN 1 .. fetchln LOOP |
||||||||||
NEW_LINE | ||||||||||
Inserts an end-of-line marker | dbms_output.new_line; | |||||||||
set serveroutput on
BEGIN FOR rec IN (SELECT table_name FROM user_tables) |
||||||||||
PUT | ||||||||||
Obsolete and no longer supported by Oracle | ||||||||||
PUT_LINE | ||||||||||
Output a literal | dbms_output.put_line(a IN VARCHAR2); | |||||||||
set serveroutput on
BEGIN |
||||||||||
Output a variable | set serveroutput on size 1000000 format wrapped
DECLARE |
最新文章
- SSIS 包部署 Package Store 后,在 IS 中可以执行,AGENT 执行却报错
- iOS设计模式之观察者模式
- 2.11 2D平面最近点对问题[closest pair problem]
- Android TextView 手动上下滑动
- 【Qt for Android】OpenGL ES 绘制彩色立方体
- The Swift Programming Language 中国版
- Linux - ubuntu中vi不能正常使用方向键与退格键的问题
- c# 几种深拷贝方式的比较
- (Java)微信之个人公众账号开发(二)——接收并处理用户消息(下)
- druid 连接池加密算法
- Python的 is 和 == 弄懂了吗?
- 开源的API文档工具框架——Swagger简介
- Python实战一
- matlab数据导入verilog仿真
- Linux dnsmasq.conf
- 如何获取Android系统APP的Package Name和Activity Name
- 自建yum源解决Ceph搭建过程中从官网取包慢的问题
- SQL语句(七)简单查询
- Java编程的逻辑 (2) - 赋值
- js 取父级 页面上的元素
热门文章
- Writing Code-Codeforces511C**
- iPhone 3gs 5.0.1降級到4.3.3 昨晚搞定(有shsh備份)
- HDU 4352 XHXJ&;#39;s LIS(数位dp&;amp;状态压缩)
- C++求解数组中出现超1/4的三个数字。
- js 对有“命名空间”的表单做深度解析
- A program to print Fahrenheit-Celsius table with floating-point values
- PL/SQL -->;隐式游标(SQL%FOUND)
- InfluxDB存储引擎Time Structured Merge Tree——本质上和LSM无异,只是结合了列存储压缩,其中引入fb的float压缩,字串字典压缩等
- 【转载】limits.h
- 如何装载Storyboard中的ViewController?