Create the output of a sequence's select in a one single text line
Hi,
The following script:
set long 1000;
set pagesize 0;
set linesize 320;
SET HEAD OFF;
SELECT dbms_metadata.get_ddl('SEQUENCE','SEQUENCE01', 'OWNER') FROM dual;
generates the following output text with break every 80 chars:
CREATE SEQUENCE "PIRAMIDE"."COD_GRUPO_CONCILIACAO" MINVALUE 1 MAXVALUE 9999
99999999999999999999999 INCREMENT BY 1 START WITH 61289 NOCACHE NOORDER NOCYCL
E
I need to generate its output in one single line, as shown below:
CREATE SEQUENCE "PIRAMIDE"."COD_GRUPO_CONCILIACAO" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 61289 NOCACHE NOORDER NOCYCLE
Is there a way to generate the output of this select, so I can get my desired single line text?
Please, inform me, ok?