Oracle选择不返回sqlplus下的所有列 [英] Oracle select not returning all columns under sqlplus

问题描述

我有以下SQL选择:

select TST_CODE ||'|'||UTI_CODE ||'|'||TST_NAME ||'|'||TST_NAME_REDUIT ||'|'||TST_GROUP ||'|'||TST_MET ||'|'||TST_MET_CODE ||'|'||TST_MET_FAMILY ||'|'||TST_MET_CALCUL ||'|'||TNS_STATUS_PAR_NM2 ||'|'||TNS_STATUS_PART_NM1 ||'|'||TNS_STATUS_PART_N ||'|'||STR_CODE ||'|'||FOUR_CODE ||'|'||TST_SIREN ||'|'||MEMO_ASC ||'|'||NAV_FICID 
from TEST_TABLE;

当我在SQL Developer中运行它时，它返回表的所有列. 但是，当我将相同的请求放入SQL文件(例如TEST_TABLE.sql)并在linux中的sqlplus下运行时，它仅返回1st 14列，即它在FOUR_CODE处停止. 知道为什么吗?

When I run it in SQL Developer it returns my all the columns of the table. But when I put the same request in an SQL file, like TEST_TABLE.sql and run it under sqlplus in linux it returns only the 1st 14 columns, that is it stops at FOUR_CODE. Any idea why?

经过调查，这是因为该列之一是数据类型CLOB.知道如何解决这个问题吗?我的TEST_TABLE.sql正在动态创建.

Edited: After investigation, it is because one of the column is of data type CLOB. Any idea how to solve this? My TEST_TABLE.sql is being dynamically created.

推荐答案

尝试放大LINESIZE，例如

Try to enlarge LINESIZE, such as

SQL> set linesize 200

如果还不够，请进一步放大.

If it is not enough, enlarge it even more.

这篇关于Oracle选择不返回sqlplus下的所有列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！