PL/SQL (MOSC)

MOSC Banner

Create the output of a sequence's select in a one single text line

in PL/SQL (MOSC) 2 commentsAnswered ✓

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center