Oracle9i™ Development by Example

Building Reports Using Oracle SQL*Plus

In Chapter 2, “Fundamentals of the SQL Language,” you learned how to use SQL*Plus to submit SQL statements to Oracle9i for execution and a result set. We have also discussed how to manipulate SQL statements in the SQL*Plus SQL buffer. Oracle9i also has a SQL buffer where all SQL statements are submitted for execution. The Oracle9i SQL buffer accepts only ANSI standard SQL statements, or just SQL—not any of the SQL*Plus buffer commands or formatting commands. Figure 6.13 shows how SQL*Plus and Oracle9i relate together. SQL*Plus (and any other program working with Oracle9i) submits its SQL statements to Oracle9i for processing via Net8. Oracle9i puts this SQL statement in the SQL buffer for execution, where ...