Oracle Magazine, September/October 2017
Database Application Developer and DBA BEYOND SQL 101 Setting Parameters for Dynamic Productivity Part 11 in a second series on the basics of the relational database and SQL This article is the 11th in a series that helps you build on the fundamentals you learned in the 12 part SQL 101 series in Oracle Magazine The previous Beyond SQL 101 article Meta Access and Repetitive Composition introduced you to the data dictionary from the USER_ ALL_ and DBA_ static data dictionary views to the dynamic performance views the V tables You saw database scripts combine multiple statements in a sequence into one file You learned what a substitution variable is and how it can help reduce SQL statement writing Last we walked through examples of how substitution variables can be reused and reset In this article you will Learn how to run a script with a parameter in SQL Plus Discover how to change the settings of the SQL Plus environment within a script ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 109 ORACLE DATABASE By Melanie Caffrey
You must have JavaScript enabled to view digital editions.