Anwarul,

you have hit a limitation of SQL Plus, which has an absolute line length limit of 2,499 characters.

This is one of my personal 'most annoying' limitations of SQL plus, the other major one being its total lack of conditional logic (a humble IF <some condition or other> is beyond it).

When extracting data from a table with numerous columns, one has no choice but to make a long statement, which will work in a development environment (e.g. TOAD) but then fail when run in SQL plus.

Since this is a limitation of SQL Plus, there is no setting or variable which will fix the problem.

Since your example contains a spool statement, I presume you're trying to get the content of the table out to a file.

All I can suggest is that you create a working table with two or three VARCHAR2(4000) fields (assuming you're not using a multi byte character set) and then concatenate the first third of the source table together and insert into the working table.

Repeat the process for the remaining two thirds of the source data.

Then your statement becomes

SELECT FIELD1||FIELD2||FIELD3 FROM MY_WORKING_TABLE;
which will be short, and won't blow the limit on SQL PLUS.

Obviously, tidy up afterwards and drop the working table.

This is messy, but is a possible solution.

Thanks for the reply.

the issue was resolved by add simple enters in my query.sql file where I had the whole thing in one line.

Thanks for the Solution. I faced the similar issue in SQL PLUS, But it worked in SQL DEVELOPER.

once again Thanks a Lot.

Thank you for reply Anwarul ,
I was also facing the same issue, and its resolved :)

It is not quite so simple to simply split lines at 2499 characters.

sqlplus will interpret certain lines STARTING with a certain character as a command. For instance, if you happen to force a line break in your SQL commands at exactly 2499 characters and the 2500th character is an @ sign then it will see it as trying to run a script instead of as a continuation of the previous line. The $ sign also seems to have weird problems.

then you have characters that are at the END of the previous line. so far we have identified that if the last printable character is a hyphen (-) then it will cause an error no matter what you do (even if there are spaces following the hyphen before the newline character).

So basically just splitting at the exact position is not necessarily going to solve your problem .... you have to be aware of the "special cases" that the dumb tool changes its behaviour for.

Hi Tom,
Thanks for your guidance.
I faced same challenge.
The code will compile in TOAD but will fail while deploying through the SQL prompt using a Deployment Tool.

My code was in the form

 <b>select column1, column2,
.
.
.
.
many columns 
 /* Somme Comments. 
Some Comments 
Some comments */
from table1, table2, 
where table1.column1 = table2.column1;</b> 

I realized that TOAD Formatter had added long spaces in the Comments section and that caused the line size to exceed the limit of 2499 characters.
On removing the extra spaces in the comments, it worked for me.

So does that mean even the long comments in the select statement can cause this issue ?

Thanks once again.
Best regads,
Maneesh Pol

Hello,

Can you please tell me how you added Enter in the Select statement.

Regards
Neeraj

Hi Anwarul Kabir,

I am facing the issue which you have sorted out. Can you please tell me how can you put enter in the Select statement which is generated at run time.

I am reading the column names from the file as mentioned below

This is the syntax for reading the file and generating the Select Statement:-

#echo `cat $Base_Dir/Files/${Stg_TblName}"_colnames_"${Run_Id}.txt`
Sql_Stmt_Str='Empty'

for i in `cat $Base_Dir/Files/${Stg_TblName}"_colnames_"${Run_Id}.txt`
do
Field=`echo $i`
if [ $Sql_Stmt_Str == 'Empty' ]
then
Sql_Stmt_Str="$Field"
else
Sql_Stmt_Str=`echo "${Sql_Stmt_Str}||'|'||$Field"`
fi
done
Final_Sql_Stmt="Select $Sql_Stmt_Str From $TblName";

Regards
Neeraj

chr(31) is a field separator
chr(13) is a carriage return (aka enter)

I agree with the solution provided (using CHR(31)). However, what I'm trying to do it to extract view definition from database (ALL_VIEWS.TEXT) and create a script and run this script in a separate schema to create views.

Problem is the ALL_VIEWS.TEXT field in some cases is exceeding 2499 characters and I'm getting the error on sqlplus SP2-0027: Input is too long (> 2499 characters) - line ignored.

Any simple solution appreciated.
Thanks!


Using database version -
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

Thank you but it doesn't seem to work either.

Here is what I did -

set serveroutput on size unlimited;

set termout on
set echo off
set heading off
set feedback off
set long 1999999999
set linesize 32767
set longchunksize 20000
set serveroutput on size unlimited format word_wrapped
set pagesize 0
set verify off
set trimspool on

spool e:\log\output.log

BEGIN
   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform,
                                      'SQLTERMINATOR',
                                      TRUE);
   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform,
                                      'PRETTY',
                                      TRUE);
   DBMS_OUTPUT.PUT_LINE( DBMS_METADATA.GET_DDL(object_type => 'VIEW', 
                                                      name => 'USER_INFO_VIEW', 
                                                      schema => 'TEST_SCHEMA'));
END;
/


spool off

Yet, the output has text > 5000 characters.

If possible, please let me know the complete script to do it right.

Thanks!

SQL> declare
  2    l_sql varchar2(32767) := 'create or replace view V as select * from dual where 1=1';
  3  begin
  4    for i in 1 .. 1000 loop
  5      l_sql := l_sql || ' and 1=1';
  6    end loop;
  7    execute immediate l_sql;
  8  end;
  9  /

PL/SQL procedure successfully completed.

SQL> BEGIN
  2     DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform,
  3                                        'SQLTERMINATOR',
  4                                        TRUE);
  5     DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform,
  6                                        'PRETTY',
  7                                        TRUE);
  8     DBMS_OUTPUT.PUT_LINE( DBMS_METADATA.GET_DDL(object_type => 'VIEW',
  9                                                        name => 'V',
 10                                                        schema => user));
 11  END;
 12  /

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "MCDONAC"."V" ("DUMMY") AS
  select "DUMMY" from dual where 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and
1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1;

PL/SQL procedure successfully completed.

SQL> show lines
linesize 130

Thanks for the reply. However, I still get unexpected results. I ran your example and it worked fine (I kept everything as is except linesize 130). But, for the view I'm trying to extract DDL, is giving me fragmented result.

Here is a test script you can try to re-produce the problem -
See the output file generated, it has lines ending with incomplete words. How to fix that?

Also I would like to replace the schema name. I found a way to remove schema name from the script but not replace it.

DBMS_METADATA.SET_TRANSFORM_PARAM(dbms_metadata.SESSION_TRANSFORM, 'EMIT_SCHEMA', false);

-- table
CREATE TABLE TEST_TAB_X
(
   BTTUUTTSSS                       NUMBER (9) NOT NULL,
   BTTUUTTSSSTW                     NUMBER (9) NOT NULL,
   VXRMSSS                          NUMBER (9) NOT NULL,
   TRUTWXXXTG_URGSSS                NUMBER (9) NOT NULL,
   XTVWXTMWTT_TBTBTXTY              NUMBER (1) NOT NULL,
   XTVWXTMWTT_TBTBTXTYSSS           NUMBER (12) NOT NULL,
   EXRMKKK                          NUMBER (9) NOT NULL,
   XUR_BTTUUTT_KWY                  VARCHAR2 (36 CHAR) NOT NULL,
   BTTUUTT_TBMW                     VARCHAR2 (100 CHAR) NOT NULL,
   BTTUUTT_BBXW_TURRWTTY            VARCHAR2 (3 CHAR) NOT NULL,
   BTTUUTT_UWTWRXTXTSSSTW           NUMBER (5) NOT NULL,
   BTTUUTT_UWTWRXTXTSSSTWSSS        NUMBER (12) NOT NULL,
   BTTUUTT_XTBTUX                   NUMBER (5) NOT NULL,
   BTTUUTT_XTBTUXSSS                NUMBER (12) NOT NULL,
   BTTXVW_UR_YURMBTT_XTBTW          NUMBER (5) NOT NULL,
   BTTXVW_UR_YURMBTT_XTBTWSSS       NUMBER (12) NOT NULL,
   WTTXTY_XTBTUX                    NUMBER (5) NOT NULL,
   WTTXTY_XTBTUXSSS                 NUMBER (12) NOT NULL,
   YWLWTW_UXWRXY                    NUMBER (9),
   YWLWTW_TXMWXTBMT                 TIMESTAMP (6) WITH TIME ZONE,
   YWLWTW_UTLXTW_YT                 DATE,
   TXGTLY_TRXVBTWSSSS               NUMBER (1) NOT NULL,
   WMTLUYWW_BTTTSSSS                NUMBER (1) NOT NULL,
   WXTWTTWY_BTTUUTT_VBLUW           NUMBER (10),
   BTTUUTT_XUBTYTWSSS               NUMBER (9) NOT NULL,
   BTTUUTT_TBRGWTSSSTWSSS           NUMBER (9) NOT NULL,
   XTTUMW_TUXTXTG_XTY               NUMBER (5) NOT NULL,
   BTTUUTT_TUMBWR                   VARCHAR2 (17 CHAR) NOT NULL,
   GAAUUAAKKK                       NUMBER (9) NOT NULL,
   GAAUUAAKKKAW                     NUMBER (9) NOT NULL,
   XAVWXAMWAA_ABABAXAY              NUMBER (1) NOT NULL,
   XAVWXAMWAA_ABABAXAYKKK           NUMBER (12) NOT NULL,
   YAAUUAA_AUMBWR                   VARCHAR2 (17 CHAR) NOT NULL,
   XTTUMW_TUXTXTG_XTYSSS            NUMBER (12) NOT NULL,
   XTVWXTMWTT_TWRVSSSS              NUMBER (1) NOT NULL,
   VX_URYWR_TRUTWXXXTG              NUMBER (5) NOT NULL,
   VX_URYWR_TRUTWXXXTGSSS           NUMBER (12) NOT NULL,
   VX_UT_UXWR_UVWRRXYWSSSS          NUMBER (1) NOT NULL,
   YWVBULT_XWTTLWMWTT_TURRWTTY      VARCHAR2 (3 CHAR),
   UVWRRXYW_TXT_XWTT_TURRSSSS       NUMBER (1) NOT NULL,
   TXT_XWTT_TURR_UXWR_UVWRRXYSSSS   NUMBER (1) NOT NULL,
   TG_WTGXTW                        NUMBER (5) NOT NULL,
   TG_WTGXTWSSS                     NUMBER (12) NOT NULL,
   TBX_YUMXTXLW_TUUTTRY             VARCHAR2 (2 CHAR),
   TBX_YUMXTXLW_TULXTXTBL_XUBYXV    NUMBER (9),
   TBXBBLW                          NUMBER (5) NOT NULL,
   TBXBBLWSSS                       NUMBER (12) NOT NULL,
   BTTUUTT_TBX_TBTWGURY             NUMBER (5) NOT NULL,
   BTTUUTT_TBX_TBTWGURYSSS          NUMBER (12) NOT NULL,
   TUXTRU_BTTT_TRWVWRWTTW           NUMBER (5) NOT NULL,
   TUXTRU_BTTT_TRWVWRWTTWSSS        NUMBER (12) NOT NULL,
   RWXTVWXT_XTY                     NUMBER (5),
   RWXTVWXT_XTYSSS                  NUMBER (12) NOT NULL,
   YWVBULT_YXXTUXXTXUT_MWTTUY       NUMBER (5) NOT NULL,
   UVWRYRBVT_UTTXUT                 NUMBER (5) NOT NULL,
   UVWRYRBVT_UTTXUTSSS              NUMBER (12) NOT NULL,
   UVWRYRBVT_UVWRRXYWSSSS           NUMBER (1),
   BTTUUTT_VRUZWT_RWBXUT            NUMBER (5) NOT NULL,
   BTTUUTT_VRUZWT_RWBXUTSSS         NUMBER (12) NOT NULL,
   BTTT_TWRXUY_WTY_MUTTT            NUMBER (5),
   BTTT_TWRXUY_WTY_MUTTTSSS         NUMBER (12) NOT NULL,
   BTTT_TWRXUY_WTY_YBY              NUMBER (5),
   RWGULBTURY_BGWTTYSSS             NUMBER (9),
   TLXWTT_TLBXXXVXTBTXUT            NUMBER (5),
   TLXWTT_TLBXXXVXTBTXUTSSS         NUMBER (12) NOT NULL,
   VUTY_BTTT_TRWVWRWTTW             NUMBER (5),
   VUTY_BTTT_TRWVWRWTTWSSS          NUMBER (12) NOT NULL,
   TUXTUYY_BTTT_TRWVWRWTTW          NUMBER (5) NOT NULL,
   TUXTUYY_BTTT_TRWVWRWTTWSSS       NUMBER (12) NOT NULL,
   RXXK_RBTXTGSSS                   NUMBER (9),
   RXXK_RBTXTG_UXWR_UVWRRXYWSSSS    NUMBER (1) NOT NULL,
   WXTTTULYXTGSSSS_VURSSSLW_TURR    NUMBER (1) NOT NULL,
   RWXXYXTG_XUBVXRMSSS              NUMBER (9),
   XTVWXTMWTT_UBJWTTXVWSSS          NUMBER (9),
   VXRM_BTTT_TLBXXSSS               NUMBER (9),
   VXRM_BTTT_XUBTLBXXSSS            NUMBER (9),
   BTTUUTT_VWR                      NUMBER (4) NOT NULL,
   VXRM_BTTT_QUBLXVXWRSSS           NUMBER (9),
   BUYXT_UXWRXY                     NUMBER (9) NOT NULL,
   BRUKWRBGW_BTTTSSSS               NUMBER (1) DEFAULT 2 NOT NULL,
   YM_LXTUTYYT                      TIMESTAMP (6) WITH TIME ZONE
                                       DEFAULT CURRENT_TIMESTAMP
                                       NOT NULL,
   BTTUUTT_RWGXXTRBTXUT_TBMW        VARCHAR2 (256 CHAR),
   TTBRXTYSSS                       VARCHAR2 (8 CHAR),
   TUUXW_BTTUUTT_MBTBGWR            VARCHAR2 (100 CHAR),
   TRWBTW_TXMWXTBMT                 TIMESTAMP (6) WITH TIME ZONE,
   TRWBTW_UTLXTW_YT                 DATE NOT NULL,
   UTYBTW_UTLXTW_YT                 DATE,
   WXTBTW_XTTWTTXUT_YBTW            DATE,
   TRWBTW_BBTTT_YT                  DATE NOT NULL,
   UTYBTW_BBTTT_YT                  DATE,
   YWLWTW_BBTTT_YT                  DATE,
   TWTXXUTSSS                       VARCHAR2 (10 CHAR),
   TBXW_RWVWRWTTW_TUM               VARCHAR2 (36 CHAR),
   TBXW_XUB_RWVWRWTTW_TUM           VARCHAR2 (36 CHAR),
   TBXW_XUBMXXXXUT_RWV              VARCHAR2 (36 CHAR),
   TBXW_TWXT_MBRKWR                 VARCHAR2 (36 CHAR),
   WXTLUYW_BWTWV_UWTWR_BTTWXXSSSS   NUMBER (1) NOT NULL,
   TURRWTTY_YXXTUXXTXUT_MWTTUY      NUMBER (5),
   TURRWTTY_YXXTUXXTXUT_MWTTUYSSS   NUMBER (12) NOT NULL,
   UX_VUTY_YXXTUXXTXUT_MWTTUY       NUMBER (5),
   UX_VUTY_YXXTUXXTXUT_MWTTUYSSS    NUMBER (12) NOT NULL,
   YWVBULT_YXXTUXXTXUT_MWTTUYSSS    NUMBER (12) NOT NULL,
   TBX_WRBT_TRUVXYWRSSS             NUMBER (9),
   TBX_WRBT_WXTWRTBL_BTTT_TUM       VARCHAR2 (50 CHAR),
   GRBTYVBTTWRWY_403BSSSS           NUMBER (1) NOT NULL,
   TRUXT_BGRWWMWTT_YT               DATE,
   BTTT_XTTWTTXUT_YT                DATE NOT NULL,
   TBX_VWTYUR_TRUVXYWRSSS           NUMBER (9),
   VWTYUR_XWRVXTW_LWVWLSSS          NUMBER (9),
   VXTBL_RWTURT_RWQSSSS             NUMBER (1) NOT NULL,
   VXTBL_RWTURT_YT                  DATE,
   TBX_VWTYUR_TUM                   VARCHAR2 (100 CHAR),
   TRUXY_RWTURTXSSSS                NUMBER (1) NOT NULL,
   TRUXY_UBJWTTXTGSSSS              NUMBER (1) NOT NULL,
   XTLXT_RWT_TUYWSSS                NUMBER (9),
   TUT_XTRBT_MGT_MTTY               NUMBER (5),
   TUT_XTRBT_MGT_MTTYSSS            NUMBER (12) NOT NULL,
   TUT_XTRBT_MGT_TBXT_TRWBT         NUMBER (5),
   TUT_XTRBT_MGT_TBXT_TRWBTSSS      NUMBER (12) NOT NULL,
   TUT_XTRBT_MGTSSSTV_TRWBT         NUMBER (5),
   TUT_XTRBT_MGTSSSTV_TRWBTSSS      NUMBER (12) NOT NULL,
   XTRBT_MGT_MTTY                   NUMBER (5),
   XTRBT_MGT_MTTYSSS                NUMBER (12) NOT NULL,
   XTRBT_MGTSSSTV_TRWBT             NUMBER (5),
   XTRBT_MGTSSSTV_TRWBTSSS          NUMBER (12) NOT NULL,
   TUT_XTRBT_MGT_RBXXW_MTTY         NUMBER (5),
   TUT_XTRBT_MGT_RBXXW_MTTYSSS      NUMBER (12) NOT NULL,
   TUT_XTRBT_RBXXW_TBXT_TRWBT       NUMBER (5),
   TUT_XTRBT_RBXXW_TBXT_TRWBTSSS    NUMBER (12) NOT NULL,
   TUT_XTRBTSSSTV_RBXXW_TRWBT       NUMBER (5),
   TUT_XTRBTSSSTV_RBXXW_TRWBTSSS    NUMBER (12) NOT NULL,
   XTRBT_MGT_RBXXW_TBXT_TRWBT       NUMBER (5),
   XTRBT_MGT_RBXXW_TBXT_TRWBTSSS    NUMBER (12) NOT NULL,
   XTRBT_MGTSSSTV_RBXXW_TRWBT       NUMBER (5),
   XTRBT_MGTSSSTV_RBXXW_TRWBTSSS    NUMBER (12) NOT NULL,
   XULUTXUTSSS                      NUMBER (9),
   MRKT_YXXTUUTT_MWTTUY             NUMBER (5),
   MRKT_YXXTUUTT_MWTTUYSSS          NUMBER (12) NOT NULL,
   MRKT_TRWMXUM_MWTTUY              NUMBER (5),
   MRKT_TRWMXUM_MWTTUYSSS           NUMBER (12) NOT NULL,
   BMURTZTXUT_TRWMXUM_VRWQ          NUMBER (5),
   BMURTZTXUT_TRWMXUM_VRWQSSS       NUMBER (12) NOT NULL,
   XT_TBLT_BT_TURTVULXUSSSS         NUMBER (1) NOT NULL,
   XTTLUYW_YXRWTT_BXXWT_XTSSSS      NUMBER (1) NOT NULL,
   XTTLUYW_YXRWTT_BXXWT_BBSSSS      NUMBER (1) NOT NULL,
   XT_XTUW_MBTBGWRXSSSS             NUMBER (1) NOT NULL,
   XT_XTUW_MBTBGWRX_YT              DATE,
   RWTURT_TKGSSS                    NUMBER (9),
   MLT_UXW_BYT_BYYRSSSS             NUMBER (1) NOT NULL,
   MLT_UXW_BYT_TBXSSSSSSS           NUMBER (1) NOT NULL,
   LBXT_TURT_TWRV_YT_TTBTGW         DATE,
   BTTT_TLBXXXVXTBTXUTSSS           NUMBER (9),
   TRUYUTTSSS                       NUMBER (9),
   RWGULBTURY_RWTURTXTG_TBRTYSSS    NUMBER (9),
   WTBBLW_BUTU_RMY_YXXBURXWSSSS     NUMBER (1) NOT NULL,
   TWXT_BYMXT_RWVXWW_YT             DATE,
   TWXT_XTVWXTMWTT_RWVXWW_YT        DATE,
   TBX_UBJWTTSSS                    VARCHAR2 (64 CHAR),
   TWLY_BWBY_BTTUUTTSSSS            NUMBER (1) NOT NULL,
   TBX_YWBR_WTY_MUTTT               NUMBER (5) NOT NULL,
   TBX_YWBR_WTY_MUTTTSSS            NUMBER (12) NOT NULL,
   UXTBX_1099_YXV_XTT_UXYSSSS       NUMBER (1) NOT NULL,
   UXTBX_1099_BRUKWRSSSS            NUMBER (1) NOT NULL,
   UXTBX_1099_MXXT_RWTWXTTSSSS      NUMBER (1) NOT NULL,
   UXTBX_1099_MXXT_YXXBURXWSSSS     NUMBER (1) NOT NULL,
   UXTBX_1041SSSS                   NUMBER (1) NOT NULL,
   UXTBX_1099RSSSS                  NUMBER (1) NOT NULL,
   UXTBX_5498SSSS                   NUMBER (1) NOT NULL,
   TYTW_UV_TRUXT                    NUMBER (5),
   TYTW_UV_TRUXTSSS                 NUMBER (12) NOT NULL,
   VXLXTG_XTBTUX                    NUMBER (5),
   VXLXTG_XTBTUXSSS                 NUMBER (12) NOT NULL,
   TBX_XWRVXTW_RWTURT_UTTXUT        NUMBER (5),
   TBX_XWRXTW_RWTURT_UTTXUTSSS      NUMBER (12) NOT NULL,
   BTTUUTT_TWRMXTBTXUT_YT           DATE,
   YU_TUT_XWTY_BTTT_XTVU_XTY        NUMBER (5) NOT NULL,
   YU_TUT_XWTY_BTTT_XTVU_XTYSSS     NUMBER (12) NOT NULL,
   XUTXBL_TUYW                      VARCHAR2 (3 CHAR),
   RWQ_RWVXWWSSSTW                  NUMBER (5),
   RWQ_RWVXWWSSSTWSSS               NUMBER (12) NOT NULL,
   LBXT_BYMXT_RWVXWW_YT             DATE,
   LBXT_XTVWXTMWTT_RWVXWW_YT        DATE,
   RYR_UTLUBY_RWTBXTSSSS            NUMBER (1),
   MRKT_YXXTUUTT_MWTTUY_TUVWR       NUMBER (5),
   MRKT_YXXTUUTT_MWTTUY_TUVWRSSS    NUMBER (12) NOT NULL,
   VXYUTXBRY_TBRTYSSS               NUMBER (9),
   WXTLUYW_XT_UX_RWGLTRY_RTRTSSSS   NUMBER (1),
   WXTLUYW_XT_MGMT_XTVUSSSS         NUMBER (1),
   TTV_BTTUUTTSSSS                  NUMBER (1) NOT NULL,
   LUXX_TBRRY_UVWR_TURRWTTY         VARCHAR2 (3 CHAR) NOT NULL,
   LT_LUXX_TBRRY_VWY_TURR_YWBR      NUMBER (12, 3),
   XT_LUXX_TBRRY_VWY_TURR_YWBR      NUMBER (12, 3),
   LT_LUXX_TBRRY_XTBTW_TURR_YWBR    NUMBER (12, 3),
   XT_LUXX_TBRRY_XTBTW_TURR_YWBR    NUMBER (12, 3),
   TRXTTXTBL_WTTRUBTTMWTTSSSS       NUMBER (1) NOT NULL,
   XGTURW_VXRM_TRUXY_BYYRSSSS       NUMBER (1) NOT NULL,
   TBX_TBY_TBTXTBL_TURTVULXUSSS     NUMBER (9),
   TBX_TBY_XTTUMW_TURTVULXUSSS      NUMBER (9),
   TBX_TBY_TURTVULXUSSSS            NUMBER (1) NOT NULL,
   LUXX_TBRRY_TUL_XUBSSS            NUMBER (9),
   LUXX_TBRRY_VXLW_UTYBTW_YT        DATE,
   LUXX_TBRRY_UXWR_UTYBTW_YT        DATE,
   WXTLUYW_BTTUUTT_VRUM_XBBSSSS     NUMBER (1),
   XWWWT_RWXTVWXT_XTY               NUMBER (5),
   XWWWT_RWXTVWXT_XTYSSS            NUMBER (12)
)
/

-- view
CREATE OR REPLACE FORCE VIEW test_view
AS
SELECT DISTINCT T.*
  FROM TEST_TAB_X T
/

-- extraction
set termout off
set echo off
set heading off
set feedback off
set long 1999999999
set linesize 130
set longchunksize 20000
set serveroutput on size unlimited format word_wrapped
set pagesize 0
set verify off
set trimspool on

spool e:\log\output.log




BEGIN
   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform,
                                      'SQLTERMINATOR',
                                      TRUE);
   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform,
                                      'PRETTY',
                                      TRUE);
   DBMS_OUTPUT.PUT_LINE( DBMS_METADATA.GET_DDL(object_type => 'VIEW',
                                                      name => 'TEST_VIEW',
                                                      schema => user));
END;
/

spool off

-- output
----------------------------------------

  CREATE OR REPLACE FORCE VIEW "TEST_USER"."TEST_VIEW" ("BTTUUTTSSS", "BTTUUTTSSSTW", "VXRMSSS", "TRUTWXXXTG_URGSSS",
"XTVWXTMWTT_TBTBTXTY", "XTVWXTMWTT_TBTBTXTYSSS", "EXRMKKK", "XUR_BTTUUTT_KWY", "BTTUUTT_TBMW", "BTTUUTT_BBXW_TURRWTTY",
"BTTUUTT_UWTWRXTXTSSSTW", "BTTUUTT_UWTWRXTXTSSSTWSSS", "BTTUUTT_XTBTUX", "BTTUUTT_XTBTUXSSS", "BTTXVW_UR_YURMBTT_XTBTW",
"BTTXVW_UR_YURMBTT_XTBTWSSS", "WTTXTY_XTBTUX", "WTTXTY_XTBTUXSSS", "YWLWTW_UXWRXY", "YWLWTW_TXMWXTBMT", "YWLWTW_UTLXTW_YT",
"TXGTLY_TRXVBTWSSSS", "WMTLUYWW_BTTTSSSS", "WXTWTTWY_BTTUUTT_VBLUW", "BTTUUTT_XUBTYTWSSS", "BTTUUTT_TBRGWTSSSTWSSS",
"XTTUMW_TUXTXTG_XTY", "BTTUUTT_TUMBWR", "GAAUUAAKKK", "GAAUUAAKKKAW", "XAVWXAMWAA_ABABAXAY", "XAVWXAMWAA_ABABAXAYKKK",
"YAAUUAA_AUMBWR", "XTTUMW_TUXTXTG_XTYSSS", "XTVWXTMWTT_TWRVSSSS", "VX_URYWR_TRUTWXXXTG", "VX_URYWR_TRUTWXXXTGSSS",
"VX_UT_UXWR_UVWRRXYWSSSS", "YWVBULT_XWTTLWMWTT_TURRWTTY", "UVWRRXYW_TXT_XWTT_TURRSSSS", "TXT_XWTT_TURR_UXWR_UVWRRXYSSSS",
"TG_WTGXTW", "TG_WTGXTWSSS", "TBX_YUMXTXLW_TUUTTRY", "TBX_YUMXTXLW_TULXTXTBL_XUBYXV", "TBXBBLW", "TBXBBLWSSS",
"BTTUUTT_TBX_TBTWGURY", "BTTUUTT_TBX_TBTWGURYSSS", "TUXTRU_BTTT_TRWVWRWTTW", "TUXTRU_BTTT_TRWVWRWTTWSSS", "RWXTVWXT_XTY",
"RWXTVWXT_XTYSSS", "YWVBULT_YXXTUXXTXUT_MWTTUY", "UVWRYRBVT_UTTXUT", "UVWRYRBVT_UTTXUTSSS", "UVWRYRBVT_UVWRRXYWSSSS",
"BTTUUTT_VRUZWT_RWBXUT", "BTTUUTT_VRUZWT_RWBXUTSSS", "BTTT_TWRXUY_WTY_MUTTT", "BTTT_TWRXUY_WTY_MUTTTSSS", "BTTT_TWRXUY_WTY_YBY",
"RWGULBTURY_BGWTTYSSS", "TLXWTT_TLBXXXVXTBTXUT", "TLXWTT_TLBXXXVXTBTXUTSSS", "VUTY_BTTT_TRWVWRWTTW", "VUTY_BTTT_TRWVWRWTTWSSS",
"TUXTUYY_BTTT_TRWVWRWTTW", "TUXTUYY_BTTT_TRWVWRWTTWSSS", "RXXK_RBTXTGSSS", "RXXK_RBTXTG_UXWR_UVWRRXYWSSSS",
"WXTTTULYXTGSSSS_VURSSSLW_TURR", "RWXXYXTG_XUBVXRMSSS", "XTVWXTMWTT_UBJWTTXVWSSS", "VXRM_BTTT_TLBXXSSS", "VXRM_BTTT_XUBTLBXXSSS",
"BTTUUTT_VWR", "VXRM_BTTT_QUBLXVXWRSSS", "BUYXT_UXWRXY", "BRUKWRBGW_BTTTSSSS", "YM_LXTUTYYT", "BTTUUTT_RWGXXTRBTXUT_TBMW",
"TTBRXTYSSS", "TUUXW_BTTUUTT_MBTBGWR", "TRWBTW_TXMWXTBMT", "TRWBTW_UTLXTW_YT", "UTYBTW_UTLXTW_YT", "WXTBTW_XTTWTTXUT_YBTW",
"TRWBTW_BBTTT_YT", "UTYBTW_BBTTT_YT", "YWLWTW_BBTTT_YT", "TWTXXUTSSS", "TBXW_RWVWRWTTW_TUM", "TBXW_XUB_RWVWRWTTW_TUM",
"TBXW_XUBMXXXXUT_RWV", "TBXW_TWXT_MBRKWR", "WXTLUYW_BWTWV_UWTWR_BTTWXXSSSS", "TURRWTTY_YXXTUXXTXUT_MWTTUY",
"TURRWTTY_YXXTUXXTXUT_MWTTUYSSS", "UX_VUTY_YXXTUXXTXUT_MWTTUY", "UX_VUTY_YXXTUXXTXUT_MWTTUYSSS", "YWVBULT_YXXTUXXTXUT_MWTTUYSSS",
"TBX_WRBT_TRUVXYWRSSS", "TBX_WRBT_WXTWRTBL_BTTT_TUM", "GRBTYVBTTWRWY_403BSSSS", "TRUXT_BGRWWMWTT_YT", "BTTT_XTTWTTXUT_YT",
"TBX_VWTYUR_TRUVXYWRSSS", "VWTYUR_XWRVXTW_LWVWLSSS", "VXTBL_RWTURT_RWQSSSS", "VXTBL_RWTURT_YT", "TBX_VWTYUR_TUM",
"TRUXY_RWTURTXSSSS", "TRUXY_UBJWTTXTGSSSS", "XTLXT_RWT_TUYWSSS", "TUT_XTRBT_MGT_MTTY", "TUT_XTRBT_MGT_MTTYSSS",
"TUT_XTRBT_MGT_TBXT_TRWBT", "TUT_XTRBT_MGT_TBXT_TRWBTSSS", "TUT_XTRBT_MGTSSSTV_TRWBT", "TUT_XTRBT_MGTSSSTV_TRWBTSSS",
"XTRBT_MGT_MTTY", "XTRBT_MGT_MTTYSSS", "XTRBT_MGTSSSTV_TRWBT", "XTRBT_MGTSSSTV_TRWBTSSS", "TUT_XTRBT_MGT_RBXXW_MTTY",
"TUT_XTRBT_MGT_RBXXW_MTTYSSS", "TUT_XTRBT_RBXXW_TBXT_TRWBT", "TUT_XTRBT_RBXXW_TBXT_TRWBTSSS", "TUT_XTRBTSSSTV_RBXXW_TRWBT",
"TUT_XTRBTSSSTV_RBXXW_TRWBTSSS", "XTRBT_MGT_RBXXW_TBXT_TRWBT", "XTRBT_MGT_RBXXW_TBXT_TRWBTSSS", "XTRBT_MGTSSSTV_RBXXW_TRWBT",
"XTRBT_MGTSSSTV_RBXXW_TRWBTSSS", "XULUTXUTSSS", "MRKT_YXXTUUTT_MWTTUY", "MRKT_YXXTUUTT_MWTTUYSSS", "MRKT_TRWMXUM_MWTTUY",
"MRKT_TRWMXUM_MWTTUYSSS", "BMURTZTXUT_TRWMXUM_VRWQ", "BMURTZTXUT_TRWMXUM_VRWQSSS", "XT_TBLT_BT_TURTVULXUSSSS",
"XTTLUYW_YXRWTT_BXXWT_XTSSSS", "XTTLUYW_YXRWTT_BXXWT_BBSSSS", "XT_XTUW_MBTBGWRXSSSS", "XT_XTUW_MBTBGWRX_YT", "RWTURT_TKGSSS",
"MLT_UXW_BYT_BYYRSSSS", "MLT_UXW_BYT_TBXSSSSSSS", "LBXT_TURT_TWRV_YT_TTBTGW", "BTTT_TLBXXXVXTBTXUTSSS", "TRUYUTTSSS",
"RWGULBTURY_RWTURTXTG_TBRTYSSS", "WTBBLW_BUTU_RMY_YXXBURXWSSSS", "TWXT_BYMXT_RWVXWW_YT", "TWXT_XTVWXTMWTT_RWVXWW_YT",
"TBX_UBJWTTSSS", "TWLY_BWBY_BTTUUTTSSSS", "TBX_YWBR_WTY_MUTTT", "TBX_YWBR_WTY_MUTTTSSS", "UXTBX_1099_YXV_XTT_UXYSSSS",
"UXTBX_1099_BRUKWRSSSS", "UXTBX_1099_MXXT_RWTWXTTSSSS", "UXTBX_1099_MXXT_YXXBURXWSSSS", "UXTBX_1041SSSS", "UXTBX_1099RSSSS",
"UXTBX_5498SSSS", "TYTW_UV_TRUXT", "TYTW_UV_TRUXTSSS", "VXLXTG_XTBTUX", "VXLXTG_XTBTUXSSS", "TBX_XWRVXTW_RWTURT_UTTXUT",
"TBX_XWRXTW_RWTURT_UTTXUTSSS", "BTTUUTT_TWRMXTBTXUT_YT", "YU_TUT_XWTY_BTTT_XTVU_XTY", "YU_TUT_XWTY_BTTT_XTVU_XTYSSS",
"XUTXBL_TUYW", "RWQ_RWVXWWSSSTW", "RWQ_RWVXWWSSSTWSSS", "LBXT_BYMXT_RWVXWW_YT", "LBXT_XTVWXTMWTT_RWVXWW_YT",
"RYR_UTLUBY_RWTBXTSSSS", "MRKT_YXXTUUTT_MWTTUY_TUVWR", "MRKT_YXXTUUTT_MWTTUY_TUVWRSSS", "VXYUTXBRY_TBRTYSSS",
"WXTLUYW_XT_UX_RWGLTRY_RTRTSSSS", "WXTLUYW_XT_MGMT_XTVUSSSS", "TTV_BTTUUTTSSSS", "LUXX_TBRRY_UVWR_TURRWTTY",
"LT_LUXX_TBRRY_VWY_TURR_YWBR", "XT_LUXX_TBRRY_VWY_TURR_YWBR", "LT_LUXX_TBRRY_XTBTW_TURR_YWBR", "XT_LUXX_TBRRY_XTBTW_TURR_YWBR",
"TRXTTXTBL_WTTRUBTTMWTTSSSS", "XGTURW_VXRM_TRUXY_BYYRSSSS", "TBX_TBY_TBTXTBL_TURTVULXUSSS", "TBX_TBY_XTTUMW_TURTVULXUSSS",
"TBX_TBY_TURTVULXUSSSS", "LUXX_TBRRY_TUL_XUBSSS", "LUXX_TBRRY_VXLW_UTYBTW_YT", "LUXX_TBRRY_UXWR_UTYBTW_YT",
"WXTLUYW_BTTUUTT_VRUM_XBBSSSS", "XWWWT_RWXTVWXT_XTY", "XWWWT_RWXTVWXT_XTYSSS") AS 
  SELECT DISTINCT
T."BTTUUTTSSS",T."BTTUUTTSSSTW",T."VXRMSSS",T."TRUTWXXXTG_URGSSS",T."XTVWXTMWTT_TBTBTXTY",T."XTVWXTMWTT_TBTBTXTYSSS",T."EXRMKKK",T
."XUR_BTTUUTT_KWY",T."BTTUUTT_TBMW",T."BTTUUTT_BBXW_TURRWTTY",T."BTTUUTT_UWTWRXTXTSSSTW",T."BTTUUTT_UWTWRXTXTSSSTWSSS",T."BTTUUTT_
XTBTUX",T."BTTUUTT_XTBTUXSSS",T."BTTXVW_UR_YURMBTT_XTBTW",T."BTTXVW_UR_YURMBTT_XTBTWSSS",T."WTTXTY_XTBTUX",T."WTTXTY_XTBTUXSSS",T.
"YWLWTW_UXWRXY",T."YWLWTW_TXMWXTBMT",T."YWLWTW_UTLXTW_YT",T."TXGTLY_TRXVBTWSSSS",T."WMTLUYWW_BTTTSSSS",T."WXTWTTWY_BTTUUTT_VBLUW",
T."BTTUUTT_XUBTYTWSSS",T."BTTUUTT_TBRGWTSSSTWSSS",T."XTTUMW_TUXTXTG_XTY",T."BTTUUTT_TUMBWR",T."GAAUUAAKKK",T."GAAUUAAKKKAW",T."XAV
WXAMWAA_ABABAXAY",T."XAVWXAMWAA_ABABAXAYKKK",T."YAAUUAA_AUMBWR",T."XTTUMW_TUXTXTG_XTYSSS",T."XTVWXTMWTT_TWRVSSSS",T."VX_URYWR_TRUT
WXXXTG",T."VX_URYWR_TRUTWXXXTGSSS",T."VX_UT_UXWR_UVWRRXYWSSSS",T."YWVBULT_XWTTLWMWTT_TURRWTTY",T."UVWRRXYW_TXT_XWTT_TURRSSSS",T."T
XT_XWTT_TURR_UXWR_UVWRRXYSSSS",T."TG_WTGXTW",T."TG_WTGXTWSSS",T."TBX_YUMXTXLW_TUUTTRY",T."TBX_YUMXTXLW_TULXTXTBL_XUBYXV",T."TBXBBL
W",T."TBXBBLWSSS",T."BTTUUTT_TBX_TBTWGURY",T."BTTUUTT_TBX_TBTWGURYSSS",T."TUXTRU_BTTT_TRWVWRWTTW",T."TUXTRU_BTTT_TRWVWRWTTWSSS",T.
"RWXTVWXT_XTY",T."RWXTVWXT_XTYSSS",T."YWVBULT_YXXTUXXTXUT_MWTTUY",T."UVWRYRBVT_UTTXUT",T."UVWRYRBVT_UTTXUTSSS",T."UVWRYRBVT_UVWRRX
YWSSSS",T."BTTUUTT_VRUZWT_RWBXUT",T."BTTUUTT_VRUZWT_RWBXUTSSS",T."BTTT_TWRXUY_WTY_MUTTT",T."BTTT_TWRXUY_WTY_MUTTTSSS",T."BTTT_TWRX
UY_WTY_YBY",T."RWGULBTURY_BGWTTYSSS",T."TLXWTT_TLBXXXVXTBTXUT",T."TLXWTT_TLBXXXVXTBTXUTSSS",T."VUTY_BTTT_TRWVWRWTTW",T."VUTY_BTTT_
TRWVWRWTTWSSS",T."TUXTUYY_BTTT_TRWVWRWTTW",T."TUXTUYY_BTTT_TRWVWRWTTWSSS",T."RXXK_RBTXTGSSS",T."RXXK_RBTXTG_UXWR_UVWRRXYWSSSS",T."
WXTTTULYXTGSSSS_VURSSSLW_TURR",T."RWXXYXTG_XUBVXRMSSS",T."XTVWXTMWTT_UBJWTTXVWSSS",T."VXRM_BTTT_TLBXXSSS",T."VXRM_BTTT_XUBTLBXXSSS
",T."BTTUUTT_VWR",T."VXRM_BTTT_QUBLXVXWRSSS",T."BUYXT_UXWRXY",T."BRUKWRBGW_BTTTSSSS",T."YM_LXTUTYYT",T."BTTUUTT_RWGXXTRBTXUT_TBMW"
,T."TTBRXTYSSS",T."TUUXW_BTTUUTT_MBTBGWR",T."TRWBTW_TXMWXTBMT",T."TRWBTW_UTLXTW_YT",T."UTYBTW_UTLXTW_YT",T."WXTBTW_XTTWTTXUT_YBTW"
,T."TRWBTW_BBTTT_YT",T."UTYBTW_BBTTT_YT",T."YWLWTW_BBTTT_YT",T."TWTXXUTSSS",T."TBXW_RWVWRWTTW_TUM",T."TBXW_XUB_RWVWRWTTW_TUM",T."T
BXW_XUBMXXXXUT_RWV",T."TBXW_TWXT_MBRKWR",T."WXTLUYW_BWTWV_UWTWR_BTTWXXSSSS",T."TURRWTTY_YXXTUXXTXUT_MWTTUY",T."TURRWTTY_YXXTUXXTXU
T_MWTTUYSSS",T."UX_VUTY_YXXTUXXTXUT_MWTTUY",T."UX_VUTY_YXXTUXXTXUT_MWTTUYSSS",T."YWVBULT_YXXTUXXTXUT_MWTTUYSSS",T."TBX_WRBT_TRUVXY
WRSSS",T."TBX_WRBT_WXTWRTBL_BTTT_TUM",T."GRBTYVBTTWRWY_403BSSSS",T."TRUXT_BGRWWMWTT_YT",T."BTTT_XTTWTTXUT_YT",T."TBX_VWTYUR_TRUVXY
WRSSS",T."VWTYUR_XWRVXTW_LWVWLSSS",T."VXTBL_RWTURT_RWQSSSS",T."VXTBL_RWTURT_YT",T."TBX_VWTYUR_TUM",T."TRUXY_RWTURTXSSSS",T."TRUXY_
UBJWTTXTGSSSS",T."XTLXT_RWT_TUYWSSS",T."TUT_XTRBT_MGT_MTTY",T."TUT_XTRBT_MGT_MTTYSSS",T."TUT_XTRBT_MGT_TBXT_TRWBT",T."TUT_XTRBT_MG
T_TBXT_TRWBTSSS",T."TUT_XTRBT_MGTSSSTV_TRWBT",T."TUT_XTRBT_MGTSSSTV_TRWBTSSS",T."XTRBT_MGT_MTTY",T."XTRBT_MGT_MTTYSSS",T."XTRBT_MG
TSSSTV_TRWBT",T."XTRBT_MGTSSSTV_TRWBTSSS",T."TUT_XTRBT_MGT_RBXXW_MTTY",T."TUT_XTRBT_MGT_RBXXW_MTTYSSS",T."TUT_XTRBT_RBXXW_TBXT_TRW
BT",T."TUT_XTRBT_RBXXW_TBXT_TRWBTSSS",T."TUT_XTRBTSSSTV_RBXXW_TRWBT",T."TUT_XTRBTSSSTV_RBXXW_TRWBTSSS",T."XTRBT_MGT_RBXXW_TBXT_TRW
BT",T."XTRBT_MGT_RBXXW_TBXT_TRWBTSSS",T."XTRBT_MGTSSSTV_RBXXW_TRWBT",T."XTRBT_MGTSSSTV_RBXXW_TRWBTSSS",T."XULUTXUTSSS",T."MRKT_YXX
TUUTT_MWTTUY",T."MRKT_YXXTUUTT_MWTTUYSSS",T."MRKT_TRWMXUM_MWTTUY",T."MRKT_TRWMXUM_MWTTUYSSS",T."BMURTZTXUT_TRWMXUM_VRWQ",T."BMURTZ
TXUT_TRWMXUM_VRWQSSS",T."XT_TBLT_BT_TURTVULXUSSSS",T."XTTLUYW_YXRWTT_BXXWT_XTSSSS",T."XTTLUYW_YXRWTT_BXXWT_BBSSSS",T."XT_XTUW_MBTB
GWRXSSSS",T."XT_XTUW_MBTBGWRX_YT",T."RWTURT_TKGSSS",T."MLT_UXW_BYT_BYYRSSSS",T."MLT_UXW_BYT_TBXSSSSSSS",T."LBXT_TURT_TWRV_YT_TTBTG
W",T."BTTT_TLBXXXVXTBTXUTSSS",T."TRUYUTTSSS",T."RWGULBTURY_RWTURTXTG_TBRTYSSS",T."WTBBLW_BUTU_RMY_YXXBURXWSSSS",T."TWXT_BYMXT_RWVX
WW_YT",T."TWXT_XTVWXTMWTT_RWVXWW_YT",T."TBX_UBJWTTSSS",T."TWLY_BWBY_BTTUUTTSSSS",T."TBX_YWBR_WTY_MUTTT",T."TBX_YWBR_WTY_MUTTTSSS",
T."UXTBX_1099_YXV_XTT_UXYSSSS",T."UXTBX_1099_BRUKWRSSSS",T."UXTBX_1099_MXXT_RWTWXTTSSSS",T."UXTBX_1099_MXXT_YXXBURXWSSSS",T."UXTBX
_1041SSSS",T."UXTBX_1099RSSSS",T."UXTBX_5498SSSS",T."TYTW_UV_TRUXT",T."TYTW_UV_TRUXTSSS",T."VXLXTG_XTBTUX",T."VXLXTG_XTBTUXSSS",T.
"TBX_XWRVXTW_RWTURT_UTTXUT",T."TBX_XWRXTW_RWTURT_UTTXUTSSS",T."BTTUUTT_TWRMXTBTXUT_YT",T."YU_TUT_XWTY_BTTT_XTVU_XTY",T."YU_TUT_XWT
Y_BTTT_XTVU_XTYSSS",T."XUTXBL_TUYW",T."RWQ_RWVXWWSSSTW",T."RWQ_RWVXWWSSSTWSSS",T."LBXT_BYMXT_RWVXWW_YT",T."LBXT_XTVWXTMWTT_RWVXWW_
YT",T."RYR_UTLUBY_RWTBXTSSSS",T."MRKT_YXXTUUTT_MWTTUY_TUVWR",T."MRKT_YXXTUUTT_MWTTUY_TUVWRSSS",T."VXYUTXBRY_TBRTYSSS",T."WXTLUYW_X
T_UX_RWGLTRY_RTRTSSSS",T."WXTLUYW_XT_MGMT_XTVUSSSS",T."TTV_BTTUUTTSSSS",T."LUXX_TBRRY_UVWR_TURRWTTY",T."LT_LUXX_TBRRY_VWY_TURR_YWB
R",T."XT_LUXX_TBRRY_VWY_TURR_YWBR",T."LT_LUXX_TBRRY_XTBTW_TURR_YWBR",T."XT_LUXX_TBRRY_XTBTW_TURR_YWBR",T."TRXTTXTBL_WTTRUBTTMWTTSS
SS",T."XGTURW_VXRM_TRUXY_BYYRSSSS",T."TBX_TBY_TBTXTBL_TURTVULXUSSS",T."TBX_TBY_XTTUMW_TURTVULXUSSS",T."TBX_TBY_TURTVULXUSSSS",T."L
UXX_TBRRY_TUL_XUBSSS",T."LUXX_TBRRY_VXLW_UTYBTW_YT",T."LUXX_TBRRY_UXWR_UTYBTW_YT",T."WXTLUYW_BTTUUTT_VRUM_XBBSSSS",T."XWWWT_RWXTVW
XT_XTY",T."XWWWT_RWXTVWXT_XTYSSS"
  FROM TEST_TAB_X T;

----------------------------------------

You have reached the SQLPLUS limit of 4000 characters. Please include some breaks in between

What can cause a change in the output of this script?

When I ran the same gawk command, I'm getting this output below. Please note in the end almost all lines are 130 characters long which indicates the problem (last word on the line is splitting) -

e:\Log>gawk "{print length($0)}" output.log
0
114
119
120
123
116
118
114
121
110
121
117
128
127
107
129
122
123
118
107
129
122
113
111
117
117
123
125
121
110
125
117
117
118
124
120
117
108
109
108
127
122
107
82
17
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
130
33
20

e:\Log>

BEGIN
   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform,
                                      'SQLTERMINATOR',
                                      TRUE);
   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform,
                                      'PRETTY',
                                      TRUE);
   DBMS_OUTPUT.PUT_LINE( replace(DBMS_METADATA.GET_DDL(object_type => 'VIEW',
                                                      name => 'TEST_VIEW',
                                                      schema => user),
                               '",','", ')                                                      
                                                      );
END;
/

Thank you for you time to respond.
It worked!!

Side note: I wonder why

format word_wrapped

can't handle what Oracle stores in the data dictionary. As a user I didn't save DDL without whitespaces. Either Oracle should have stored DDL with whitespaces or

format word_wrapped

should have used comma as a separator (not white spaces).

I encountered "Input is too long (> 2499 characters) - line ignored" with my query, and redirecting the SQL to a file (lets say query_file=/home/user/mysql.sql ) and running the SQL from file using -s as below solved the problem

sqlplus -s pwd/user@db << EOF_SQL > dev/null
SET HEADING OFF
SET ECHO OFF
SET FEEDBACK OFF
SET PAGESIZE 0
SET ARRAYSIZE 3000
SET TRIMS ON
WHENEVER SQLERROR EXIT SQL.SQLCODE
SPOOL ${spool_file}
@ ${query_file}
SPOOL OFF;
exit;
EOF_SQL