Oracle Magazine, September/October 2017
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 119 set verify off set linesize 60 set pagesize 100 set feedback off set termout on select table_ name num_ rows to_ char last_ analyzed DD MON YYYY HH24 MI SS last_ analyzed from user_ tables where table_ name like 1 and num_ rows 2 spool off Run the script at the SQL Plus command prompt SQL @ parameterize_ your_ script sql EMPLOYEE 10 p table border 1 width 90 align center summary Script output tr th scope col TABLE_ NAME th th scope col NUM_ ROWS th
You must have JavaScript enabled to view digital editions.