Oracle Magazine, July/August 2017
Database Application Developer and DBA BEYOND SQL 101 EMPLOYEE EMP_ DEPT_ FK DEPARTMENT_ ID 1 EMPLOYEE EMPLOYEE_ WAGE_ INC_ WORTH_ BMI WAGE_ INCREASE_ WORTHINESS 1 ORACLE MAGAZINE JULY AUGUST 2017 118 6 rows selected Code Listing 11 Using to avoid repeated prompted user input for substitution variables Create a database script called substitute_ and_ reuse sql select table_ name num_ rows to_ char last_ analyzed DD MON YYYY HH24 MI SS last_ analyzed from user_ tables where table_ name v_ table select table_ name index_ name column_ name column_ position from user_ ind_ columns where table_ name v_ table Execute the script SQL @ substitute_ and_ reuse sql Enter value for v_ table EMPLOYEE old 3 where table_ name v_ table new 3 where table_ name EMPLOYEE TABLE_ NAME NUM_ ROWS LAST_ ANALYZED EMPLOYEE 16 13 MAY 2017 14 46 32
You must have JavaScript enabled to view digital editions.