backup Sequence script

SET PAGESIZE 0
SET ECHO OFF FEED OFF TERM OFF HEADING OFF TRIMS OFF
SET COLSEP '|'
SET TRIMSPOOL ON
SET LINESIZE 10000
SET TRIMSPOOL ON
SET LINESIZE 10000
SET NEWPAGE 1
SPOOL d:\\sequence_bak.sql

SELECT 'drop sequence ' || sequence_name || ';' a
FROM dba_sequences
WHERE sequence_owner = 'FWD'
UNION ALL
SELECT 'create sequence '
|| sequence_name
|| ' minvalue '
|| min_value
|| ' maxvalue '
|| max_value
|| ' start with '
|| last_number
|| ' increment by '
|| increment_by
|| (CASE
WHEN cache_size = 0 THEN ' nocache'
ELSE ' cache ' || cache_size
END)
|| ';'
a
FROM dba_sequences
WHERE sequence_owner = 'FWD';

SPOOL OFF