Books & Videos

Table of Contents

  1. Chapter 1 Introduction to SQL*Plus

    1. What Is SQL*Plus?

    2. History of SQL*Plus

    3. Why Master SQL*Plus?

    4. Creating and Loading the Sample Tables

  2. Chapter 2 Interacting with SQL*Plus

    1. Starting SQL*Plus

    2. Some Basic SQL*Plus Commands

    3. Running SQL Queries

    4. Working with PL/SQL

    5. The SQL Buffer

    6. Line Editing

    7. Executing the Statement in the Buffer

    8. Saving and Retrieving the Buffer

    9. The EDIT Command

    10. Executing a Script

    11. The Working Directory

  3. Chapter 3 Generating Reports with SQL*Plus

    1. Following a Methodology

    2. Saving Your Work

    3. Designing a Simple Report

    4. Advanced Report Formatting

    5. Totals and Subtotals

    6. Other Reporting Topics

  4. Chapter 4 Writing SQL*Plus Scripts

    1. Why Write Scripts?

    2. Using Substitution Variables

    3. Prompting for Values

    4. Cleaning Up the Display

    5. Packaging Your Script

    6. The DEFINE and UNDEFINE Commands

    7. Controlling Variable Substitution

    8. Commenting Your Scripts

  5. Chapter 5 Extracting and Loading Data

    1. Types of Output Files

    2. Limitations of SQL*Plus

    3. Extracting the Data

    4. Reloading the Data

  6. Chapter 6 Exploring Your Database

    1. The DESCRIBE Command

    2. Oracle’s Data Dictionary Views

    3. Tables

    4. Table Constraints

    5. Indexes

    6. Triggers

    7. Synonyms

    8. Table Security

    9. Finding More Information

  7. Chapter 7 Advanced Scripting

    1. Bind Variables

    2. Branching in SQL*Plus

    3. Looping in SQL*Plus

    4. Validating and Parsing User Input

    5. Error Handling

  8. Chapter 8 Tuning and Timing

    1. Using SQL*Plus Timers

    2. Using EXPLAIN PLAN

    3. Using AUTOTRACE

    4. Improving on EXPLAIN PLAN Results

    5. Where to Find More Tuning Information

  9. Chapter 9 The Product User Profile

    1. What Is the Product User Profile?

    2. Using the Product User Profile

  10. Chapter 10 Administration with SQL*Plus

    1. Connecting for Administrative Purposes

    2. Starting and Stopping a Database

    3. Looking at Your Database

    4. Database Backup and Recovery

  11. Chapter 11 Customizing Your SQL*Plus Environment

    1. SQL*Plus Settings You Can Control

    2. The Site and User Profiles

    3. Environment Variable Settings

    4. The SET Command

    5. The SHOW Command

  1. Appendix SQL*Plus Command Reference

    1. SQLPLUS

    2. Comment Delimiters (/*...*/)

    3. Double Hyphen (- -)

    4. At Sign (@)

    5. Double At Sign (@@)

    6. Forward Slash (/)

    7. ACCEPT

    8. APPEND

    9. ARCHIVE LOG

    10. ATTRIBUTE

    11. BREAK

    12. BTITLE

    13. CHANGE

    14. CLEAR

    15. COPY

    16. COLUMN

    17. COMPUTE

    18. CONNECT

    19. DEFINE

    20. DEL

    21. DESCRIBE

    22. DISCONNECT

    23. EDIT

    24. EXECUTE

    25. EXIT

    26. GET

    27. HELP

    28. HOST

    29. INPUT

    30. LIST

    31. PASSWORD

    32. PAUSE

    33. PRINT

    34. PROMPT

    35. QUIT

    36. RECOVER

    37. REMARK

    38. REPFOOTER

    39. REPHEADER

    40. RUN

    41. SAVE

    42. SET

    43. SHOW

    44. SHUTDOWN

    45. SPOOL

    46. START

    47. STARTUP

    48. STORE

    49. TIMING

    50. TTITLE

    51. UNDEFINE

    52. VARIABLE

    53. WHENEVER

  2. Appendix SQL*Plus Format Elements

    1. Formatting Numbers

    2. Formatting Character Strings

    3. Formatting Dates

  3. Colophon