O'Reilly logo

Sams Teach Yourself SQL in One Hour a Day, Fifth Edition by Arie D. Jones, Ron Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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”) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required