SELECT /*insert*/* FROM ALT;

REM INSERTING into ALT
    SET DEFINE OFF;
    Insert into ALT (ENA,DYO) values ('2','3');
    Insert into ALT (ENA,DYO) values ('1','2');

set echo off
set pagesize 0
set long 90000
SPOOL C:Export15.sql;


SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
    FROM USER_TABLES u;
SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)
    FROM USER_INDEXES u;

SELECT DBMS_METADATA.GET_DDL('CONSTRAINT',u.constraint_name)
    FROM USER_CONSTRAINTS u;

select /*insert*/* from ALT ;--I WANT IT FOR ALL TABLES IN DATABASE AND NOT ONE BY ONE

SPOOL OFF;