Oracle Magazine, September/October 2017
Database Application Developer and DBA BEYOND SQL 101 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 ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 115 and num_ rows 2 spool off Run the script at the SQL Plus command prompt SQL @ parameterize_ your_ script sql EMPLOYEE 10 TABLE_ NAME NUM_ ROWS LAST_ ANALYZED EMPLOYEE 16 13 MAY 2017 14 46 32 EMPLOYEE_ IDENTITY 16 04 JAN 2017 01 00 32 EMPLOYEE_ SUBSET 16 11 MAY 2017 21 48 06 View the contents of your spooled output file TABLE_ NAME NUM_ ROWS LAST_ ANALYZED EMPLOYEE 16 13 MAY 2017 14 46 32 EMPLOYEE_ IDENTITY 16 04 JAN 2017 01 00 32 EMPLOYEE_ SUBSET 16 11 MAY 2017 21 48 06 The SQL Plus SPOOL command used together with a filename of your choosing spools the results of any SQL Plus or SQL commands issued subsequently to your
You must have JavaScript enabled to view digital editions.