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