sys @ TEST_LUNAR> set heading onsys @ TEST_LUNAR> set feedback onsys @ 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 ('*', 2 * (ROWNUM-1) 1, '*') 5) 6 from all_Objects 7, (Select 10 as maxwidth from dual) 8 Where rownum
* * * * * * * * * *
Sys @ Test_lunar> SYS @ Test_lunar> Set Heading Onsys @ Test_lunar> Set Feedback Onsys @ Test_lunar>