LESSON 25Using Oracle SQL*Plus to Satisfy Reporting Needs
In this lesson, you learn about SQL*Plus, the SQL interface for Oracle’s relational database management system (RDBMS). By the end of the lesson, you will understand the following elements of SQL*Plus:
• How to use the SQL*Plus buffer
• How to attractively format reports
• How to manipulate dates
• How to make interactive queries
• How to construct advanced reports
• How to use the powerful DECODE function
An Introduction to SQL*Plus
We are presenting SQL*Plus in this lesson because of Oracle’s dominance in the relational database market and because of the power and flexibility SQL*Plus offers to the database user. SQL*Plus resembles Transact-SQL (see Lesson 27, “An Introduction to Transact-SQL”) ...
Get Sams Teach Yourself SQL in One Hour a Day, Fifth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
