Oracle PL/SQL/Report Column Page/Line Width

Set line width to 300 characters

   <source lang="sql">

SQL> set lin 300; SQL> SQL> --Getting information on sequences SQL> SQL> SQL> CREATE SEQUENCE StudentNumSeq

 2    INCREMENT BY 1
 3    START WITH 1100
 4    MAXVALUE 99999
 5    NOCACHE
 6    NOCYCLE;

Sequence created. SQL> SQL> SQL> SQL> select * from ALL_SEQUENCES; SEQUENCE_OWNER SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE L AST_NUMBER

---

------------------------------ ------------------------ ------------------------ ------------------------ - - ------------------------ --------------

---

SYS UGROUP_SEQUENCE .00 ######################## 1.00 N Y 10.00

 1.00

SYS OBJECT_GRANT 1.00 ######################## 1.00 N Y 20.00

  5421.00

SYS SYSTEM_GRANT 1.00 ######################## 1.00 N Y 20.00 690.00 SYS PROFNUM$ .00 ######################## 1.00 N N .00

 1.00

SYS AUDSES$ 1.00 2000000000.00 1.00 Y N 20.00

82.00

SYS SNAPSHOT_ID$ 1.00 2147483647.00 1.00 N N 20.00

 1.00

SYS SNAPSITE_ID$ 1.00 4294967295.00 1.00 N N 20.00

 1.00

SYS JOBSEQ 1.00 999999999.00 1.00 Y N 20.00

21.00

SYS RGROUPSEQ 1.00 999999999.00 1.00 Y N 20.00

 1.00

SYS ORA_TQ_BASE$ 1.00 4294967.00 1.00 Y N .00

 7.00

SYS PARTITION_NAME$ 1.00 ######################## 1.00 N N 20.00

21.00

SEQUENCE_OWNER SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE L AST_NUMBER

---

------------------------------ ------------------------ ------------------------ ------------------------ - - ------------------------ --------------

---

SYS CDC_SUBSCRIBE_SEQ$ 1.00 ######################## 1.00 N N 20.00

 1.00

SYS CDC_RSID_SEQ$ 1.00 ######################## 1.00 N Y 10000.00 SQL> SQL>

      </source>