Oracle截断列 [英] Oracle truncating column

问题描述

我有以下查询.

insert into ORDER_INFO(ORDINF_PK,ORDINF_LGNDET_PK_FK,MEDIA_TYPE,ORDINF_MUSIC_FK,DAT)
values (1,1,'Music',21,TO_DATE('14-OCT-2015','DD-MON-YYYY'));

insert into ORDER_INFO(ORDINF_PK,ORDINF_LGNDET_PK_FK,MEDIA_TYPE,ORDINF_MUSIC_FK,ORDINF_SERIES_FK,DAT)
values (2,2,'Series',71,23,TO_DATE('07-NOV-2015','DD-MON-YYYY'));

不过我什么时候做:

select * from ORDER_INFO;

我得到:

truncating (as requested) before column ORDINF_SERIES_FK

truncating (as requested) before column ORDINF_MOVIES_FK

 ORDINF_PK ORDINF_LGNDET_PK_FK           MEDIA_TYPE ORDINF_MUSIC_FK      DAT
---------- ------------------- -------------------- --------------- ---------
     1                       1                Music              21 14-NOV-14
     2                       2               Series              71 07-NOV-15

我知道它会截断ORDINF_MOVIES_FK，因为该列中没有条目，但是为什么它会截断ORDINF_SERIES_FK列?

I understand that it is truncating ORDINF_MOVIES_FK because there is no entry in that column, but why is it truncating the column ORDINF_SERIES_FK?

推荐答案

我设法解决了这个问题，我做到了.

I managed to solve the issue, I did this.

set wrap on;
set pagesize 50000;
set linesize 120;

此处链接: http://www.anattatechnologies. com/q/2012/01/sqlplus-pagesize-and-linesize/

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