替代dbms_output.putline [英] Alternative to dbms_output.putline

问题描述

我正在过程中创建动态查询，现在想通过dbms_output.putline查看它，但是我的查询包含超过255个字符.

I am creating a dynamic query in a procedure and now want to see it through dbms_output.putline, but my query contains more than 255 characters.

如何查看查询?

dbms_output.putline的替代项是什么?

推荐答案

有点混乱.

在Oracle 9i中，dbms_output.put_line 限制为255字符.此限制已在10g中删除，并且类似 Oracle 11g 中不存在.

In Oracle 9i dbms_output.put_line is limited to 255 characters. This restriction was removed in 10g and is similarly not present in Oracle 11g.

您已标记问题 oracle10g 的问题表示您被限制为32,767字节，这是标准的PL/SQL最大值.

You have tagged your question oracle10g, which means that you're limited to 32,767 bytes, the standard PL/SQL maximum.

这篇关于替代dbms_output.putline的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！