Oracle Magazine, September/October 2017
Database Application Developer and DBA BEYOND SQL 101 Name Null Type EMPLOYEE_ ID NOT NULL NUMBER FIRST_ NAME VARCHAR2 30 LAST_ NAME VARCHAR2 30 HIRE_ DATE DATE SALARY NUMBER 92 MANAGER NUMBER DEPARTMENT_ ID NUMBER WAGE_ INCREASE_ WORTHINESS VARCHAR2 40 EMP_ FULL_ NAME VARCHAR2 70 CREATED_ ON DATE CREATED_ BY NUMBER UPDATED_ ON DATE UPDATED_ BY NUMBER FINISHING THE HAT Once you have a dynamically generated SQL statement file such as create_ audit_ columns sql it is a good idea to save it and add comment lines to the file similar to those illustrated in the example in Listing 11 The double hyphen lines at the top of the create_ audit_ columns sql file denote single line comments Alternatively you can use the REMARK or REM command as demonstrated in the script you used to create the tables for the SQL_ 201 schemas used for this articles examples or the single or multiline comment delimiters Similar comment lines should also be added to your dynamic SQL scripts for reusability and documentation purposes ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 126
You must have JavaScript enabled to view digital editions.