sql語言教程les-資料下載頁
2025-07-24 15:06本頁面
【正文】 and footers. ? Set the report header. ? Set the report footer. TTI[TLE] [text|OFF|ON] TTITLE 39。Salary|Report39。 BTITLE 39。Confidential39。 724 Copyright 169。 Oracle Corporation, 2022. All rights reserved. Creating a Script File to Run a Report 1. Create and test the SQL SELECT statement. 2. Save the SELECT statement into a script file. 3. Load the script file into an editor. 4. Add formatting mands before the SELECT statement. 5. Verify that the termination character follows the SELECT statement. 725 Copyright 169。 Oracle Corporation, 2022. All rights reserved. Creating a Script File to Run a Report 6. Clear formatting mands after the SELECT statement. 7. Save the script file. 8. Load the script file into the iSQL*Plus text window, and click the Execute button. 726 Copyright 169。 Oracle Corporation, 2022. All rights reserved. Sample Report … 727 Copyright 169。 Oracle Corporation, 2022. All rights reserved. Sample Report … 728 Copyright 169。 Oracle Corporation, 2022. All rights reserved. Summary In this lesson, you should have learned how to: ? Use iSQL*Plus substitution variables to store values temporarily ? Use SET mands to control the current iSQL*Plus environment ? Use the COLUMN mand to control the display of a column ? Use the BREAK mand to suppress duplicates and divide rows into sections ? Use the TTITLE and BTITLE mands to display headers and footers 729 Copyright 169。 Oracle Corporation, 2022. All rights reserved. Practice 7 Overview This practice covers the following topics: ? Creating a query to display values using substitution variables ? Starting a mand file containing variable
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號(hào)-1