Oracle Truncating Column

I have the following query. 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')); inse

Solution 1:

I managed to solve the issue, I did this.

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

link here: http://www.anattatechnologies.com/q/2012/01/sqlplus-pagesize-and-linesize/

Solution 2:

Pay attention - both rows inserted and ARE in the database, so INSERT succeeded. The warning you get is a warning from SQLPlus program that means that column is display not with full width (maybe the definition of column is long and SQLPlus decides to show column shorter because data you have in there is short). You do not need to worry about this in any case.

See this link for more explanation about SQL*Plus wrap.