Oracle Magazine, July/August 2017
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE JULY AUGUST 2017 117 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 @ resubstitute 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 Enter value for v_ table EMPLOYEE old 3 where table_ name v_ table new 3 where table_ name EMPLOYEE TABLE_ NAME INDEX_ NAME COLUMN_ NAME COLUMN_ POSITION EMPLOYEE EMP_ HIRE_ DATE_ I HIRE_ DATE 1 EMPLOYEE DEP_ WAGE_ INCREASE_ I DEPARTMENT_ ID 1 EMPLOYEE DEP_ WAGE_ INCREASE_ I WAGE_ INCREASE_ WORTHINESS 2 EMPLOYEE EMPLOYEE_ PK EMPLOYEE_ ID 1
You must have JavaScript enabled to view digital editions.