sys @ TEST_LUNAR> set heading onsys @ TEST_LUNAR> set feedback onsys @ TEST_LUNAR> sys @ TEST_LUNAR> set heading offsys @ TEST_LUNAR> set feedback offsys @ TEST_LUNAR> set pagesize 2000sys @ TEST_LUNAR> sys @ TEST_LUNAR> select decode 2 (sign (floor ( Maxwidth / 2) -rownum 3, 1, lpad ('', floor (maxwidth / 2) - (ROWNUM-1)) 4 || RPAD (CHR (257), 2 * (ROWNUM-1) 1, ' '|| CHR (257)) 5, LPAD (CHR (257) || CHR (257) || CHR (257), FLOOR (MaxWidth / 2) 3)) 6 from all_Objects 7, (Select 25 As MaxWidth from Dual) 8 WHERE ROWNUM
Sys @ Test_lunar> SYS @ Test_lunar> Set Heading Onsys @ Test_lunar> Set Feedback Onsys @ Test_lunar> Sys @ Test_lunar>