Subscribe

Author Profile

Melanie Caffrey

Melanie Caffrey is a senior development manager at Oracle. She is a coauthor of Beginning Oracle SQL for Oracle Database 12c (Apress, 2014), Expert PL/SQL Practices for Oracle Developers and DBAs (Apress, 2011), and Expert Oracle Practices: Oracle Database Administration from the Oak Table (Apress, 2010).

Limited Profiles and Private References

Part 13 in a second series on the basics of the relational database and SQL By Melanie Caffrey January/February 2018 This article is the thirteenth, and last, in a...

Becoming Privileged and Creating Synonymously

Part 12 in a second series on the basics of the relational database and SQL By Melanie Caffrey November/December 2017 This article is the 12th in a series that...

Setting Parameters for Dynamic Productivity

Part 11 in a second series on the basics of the relational database and SQL By Melanie Caffrey September/October 2017 This article is the 11th in a series that...

Meta-Access and Repetitive Composition

Part 10 in a second series on the basics of the relational database and SQL By Melanie Caffrey July/August 2017 This article is the 10th in a series that helps...

The Cost of Data Retrieval

Part 9 in a second series on the basics of the relational database and SQL By Melanie Caffrey May/June 2017 This article is the ninth in a series that helps you bui...

Rapid Retrieval of Rows in Small Data Sets

Part 8 in a second series on the basics of the relational database and SQL By Melanie Caffrey March/April 2017 This article is the eighth in a series that helps...

Sequential Additions and Different Points of View

Part 7 in a second series on the basics of the relational database and SQL By Melanie Caffrey January/February 2017 This article is the seventh in a series that...

Defining, Constraining, and Manipulating Your Entities

Part 6 in a second series on the basics of the relational database and SQL By Melanie Caffrey November/December 2016 This article is the sixth in a series that...

Changing and Creating Consistently with Integrity

Part 5 in a second series on the basics of the relational database and SQL By Melanie Caffrey September/October 2016 This article is the fifth in a series that...