List of Examples
- 3-1 Using the SQL SELECT Statement to Query All Data From a Table
- 3-2 Using the SQL SELECT Statement to Query Data From Specific Columns
- 3-3 Using the SQL SELECT Statement to Query Data in a View
- 3-4 Using a Column Alias for a Descriptive Heading in a SQL Query
- 3-5 Selecting Data With the SQL WHERE Clause to Restrict Data
- 3-6 Using Regular Expressions With the SQL SELECT Statement
- 3-7 Selecting Data With the SQL ORDER BY Clause to Sort the Data
- 3-8 Selecting Data From Two Tables With the SQL NATURAL JOIN Syntax
- 3-9 Selecting Data From Multiple Tables WIth the SQL JOIN USING Syntax
- 3-10 Selecting Data From Multiple Tables With the SQL JOIN ON Syntax
- 3-11 Self Joining a Table With the SQL JOIN ON Syntax
- 3-12 Using SQL Outer Joins
- 3-13 Using the SQL SYSDATE Pseudocolumn
- 3-14 Using the SQL USER Pseudocolumn
- 3-15 Using the SQL ROWNUM Pseudocolumn
- 3-16 Using SQL Arithmetic Operators
- 3-17 Using SQL Numeric Functions
- 3-18 Using SQL Character Functions
- 3-19 Using SQL Date Functions
- 3-20 Using the SQL Character Conversion Function
- 3-21 Using the SQL Number Conversion Function
- 3-22 Using SQL Date Conversion Functions
- 3-23 Using SQL Aggregate Functions
- 3-24 Using the SQL NVL Function
- 3-25 Using the SQL NVL2 Function
- 3-26 Using the SQL CASE Function
- 3-27 Using the SQL DECODE Function
- 3-28 Using the SQL INSERT Statement to Add Rows to a Table
- 3-29 Using the SQL UPDATE Statement to Update Data in a Table
- 3-30 Using the SQL DELETE Statement to Remove Rows From a Table
- 3-31 Using the SQL COMMIT Statement to Save Changes
- 3-32 Using the SQL ROLLBACK Statement to Undo Changes
- 3-33 Creating a Simple Table Using SQL
- 3-34 Creating a Table With NOT NULL Constraints Using SQL
- 3-35 Adding, Altering, and Dropping a Table Column Using SQL
- 3-36 Creating, Altering, and Dropping Constraints Using SQL
- 3-37 Renaming a Table Using SQL
- 3-38 Dropping a Table Using SQL
- 3-39 Creating, Modifying, and Dropping an Index Using SQL
- 3-40 Creating a View Using SQL
- 3-41 Dropping a View Using SQL
- 3-42 Creating a Sequence Using SQL
- 3-43 Dropping a Sequence Using SQL
- 3-44 Creating a Synonym Using SQL
- 3-45 Dropping a Synonym Using SQL
- 4-1 Using a Simple PL/SQL Block
- 4-2 Using DBMS_OUTPUT.PUT_LINE to Display PL/SQL Output
- 4-3 Using Comments in PL/SQL
- 4-4 Declaring Variables in PL/SQL
- 4-5 Using Identifiers for Variables in PL/SQL
- 4-6 Assigning Values to Variables With the PL/SQL Assignment Operator
- 4-7 Using Numeric Literals in PL/SQL
- 4-8 Using Character Literals in PL/SQL
- 4-9 Using String Literals in PL/SQL
- 4-10 Using BOOLEAN Literals in PL/SQL
- 4-11 Using Date-time Literals in PL/SQL
- 4-12 Using DEFAULT and NOT NULL in PL/SQL
- 4-13 Assigning Values to Variables Using PL/SQL SELECT INTO
- 4-14 Using %TYPE With Table Columns in PL/SQL
- 4-15 Using %ROWTYPE with a PL/SQL Record
- 4-16 Using a Simple IF-THEN Statement in PL/SQL
- 4-17 Using the IF-THEN-ELSEIF Statement in PL/SQL
- 4-18 Using the CASE-WHEN Statement in PL/SQL
- 4-19 Using the IF-THEN_ELSE and CASE Statement in PL/SQL
- 4-20 Using the FOR-LOOP in PL/SQL
- 4-21 Using WHILE-LOOP for Control in PL/SQL
- 4-22 Using the EXIT-WHEN Statement in PL/SQL
- 4-23 Using the GOTO Statement in PL/SQL
- 4-24 Declaring a Local PL/SQL Procedure With IN OUT Parameters
- 4-25 Declaring a Local PL/SQL Function With IN Parameters
- 4-26 Declaring a Complex Local Procedure in a PL/SQL Block
- 4-27 Fetching a Single Row With a Cursor in PL/SQL
- 4-28 Fetching Multiple Rows With a Cursor in PL/SQL
- 4-29 Passing Parameters to a Cursor in PL/SQL
- 4-30 Using a Cursor Variable (REF CURSOR)
- 4-31 Declaring and Initializing a PL/SQL Record Type
- 4-32 Using %ROWTYPE With a Cursor When Declaring a PL/SQL Record
- 4-33 Using a PL/SQL VARRAY Type With Character Elements
- 4-34 Using a PL/SQL VARRAY Type With Record Type Elements
- 4-35 Using Dynamic SQL to Manipulate Data in PL/SQL
- 4-36 Using Dynamic SQL to Create a Table in PL/SQL
- 4-37 Managing Multiple Errors With a Single PL/SQL Exception Handler
- 4-38 Determining the Scope of PL/SQL Exceptions
- 4-39 Continuing After an Exception in PL/SQL
- 5-1 Creating a Simple Stored Procedure
- 5-2 Creating a Stored Procedure That Uses Parameters
- 5-3 Creating a Stored Procedure With the AUTHID Clause
- 5-4 Creating a Stored Function That Returns a String
- 5-5 Creating a Stored Function That Returns a Number
- 5-6 Techniques for Calling Stored Procedures or Functions
- 5-7 Dropping Subprograms With the DROP Statement
- 5-8 Creating a Package Specification
- 5-9 Creating a Package Body
- 5-10 Calling a Subprogram in a Package
- 5-11 Creating Variables in a PL/SQL Package Specification
- 5-12 Using Variables From a Package Specification
- 5-13 Creating Types and Variables in a PL/SQL Package Specification
- 5-14 Using the emp_refcur_typ REF CURSOR From a Package Specification
- 5-15 Using the my_refcur_typ REF CURSOR From a Package Specification
- 5-16 Using the DBMS_RANDOM Package
- 5-17 Using HTP Print Procedure
- 5-18 Setting up a Directory for Use With UTL_FILE
- 5-19 Using the UTL_FILE Package
- 6-1 Creating a Database Trigger WIth the AFTER Option
- 6-2 Creating a Database Trigger With the BEFORE Option
- 6-3 Creating a View That is Updated With an INSTEAD OF Trigger
- 6-4 Creating an INSTEAD OF Trigger for Updating a View
- 6-5 Creating a Database Trigger With an Exception Handler
- 6-6 Creating a Trigger That Fires Only Once
- 6-7 Creating a LOGON Trigger
- 6-8 Creating a LOGOFF Trigger
- 6-9 Dropping Triggers
- 6-10 Disabling a Specific Trigger
- 6-11 Disabling All Triggers on a Table
- 6-12 Enabling a Specific Trigger
- 6-13 Enabling All Triggers for a Table
- 6-14 Viewing the Dependencies for a Trigger
- 6-15 Recompiling a Trigger
- 7-1 Setting NLS_LANGUAGE=ITALIAN
- 7-2 Setting NLS_LANGUAGE=GERMAN
- 7-3 Setting NLS_LANGUAGE=AMERICAN, NLS_TERRITORY=AMERICA
- 7-4 Setting NLS_LANGUAGE=AMERICAN and NLS_TERRITORY=GERMANY
- 7-5 Using the Default, Short, and Long Date Formats
- 7-6 Setting NLS_DATE_LANGUAGE=FRENCH: Month and Day
- 7-7 Setting NLS_TIMESTAMP_TZ_FORMAT
- 7-8 Setting NLS_CALENDAR='English Hijrah'
- 7-9 Setting NLS_NUMERIC_CHARACTERS=",."
- 7-10 Displaying the Local Currency Symbol
- 7-11 Setting NLS_ISO_CURRENCY=FRANCE
- 7-12 Setting NLS_SORT to BINARY
- 7-13 Setting NLS_SORT to Spanish
- 7-14 Setting NLS_COMP to BINARY
- 7-15 Setting NLS_COMP to LINGUISTIC
- 7-16 Setting Length Semantics and Creating a Table
- 7-17 Setting NLS_DATE_LANGUAGE=American, NLS_CALENDAR=Gregorian
- 7-18 Setting NLS_LANGUAGE in a Query
- 7-19 Using NLS Parameters in SQL Functions
- A-1 Prompting for a Variable Value in SQL Command Line
- A-2 Reusing a Variable Value in SQL Command Line
- A-3 Defining a Variable for a Query in SQL Command Line
- C-1 Creating a PHP Program for Use With a PL/SQL Procedure
- D-1 Creating a Java Program for Use With a PL/SQL Procedure