Why sql plus doesn't include all the data from my coil column

Question

I use SQLPLUS to transfer data to a file, but not all data is returned? I use a function dbms_metadata.get_ddland it returns part of the table definition to a file .... where I can see the full definition in the query output.

I installed linesize = 8000in a spool kit?

SQL:

Select dbms_metatdata.get_ddl('TABLE',at.table_name)
From all_tables at
Where at.owner = 'MYTEST';

Withdrawal:

CREATE TABLE "MYTEST"."TESTTABLE3"
(   "ID" NUMBER(10,0),
"DESCRIPTION" V

CREATE TABLE "MYTEST"."MYPARENT"
(   "PARENT_ID" NUMBER(10,0) NOT NULL ENAB

Completely clip output?

Answer 1

Try set long 1000000000