Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\target.db
<?xml version="1.0" encoding="UTF-8"?> <div element="book" href="toc.htm" number="" targetptr=""> <ttl>Oracle Database 2 Day Developer's Guide</ttl> <xreftext><cite> Oracle Database 2 Day Developer's Guide</cite></xreftext> <div element="chapter" href="tdddg_intro.htm" number="1" targetptr="TDDDG10000"> <ttl>Introduction</ttl> <xreftext>“Introduction”</xreftext> <div element="sect1" href="tdddg_intro001.htm" number="1.1" targetptr="TDDDG99967"> <ttl>About Oracle Database Developers</ttl> <xreftext>“About Oracle Database Developers”</xreftext> </div> <div element="sect1" href="tdddg_intro002.htm" number="1.2" targetptr="TDDDG1110"> <ttl>About This Document</ttl> <xreftext>“About This Document”</xreftext> </div> <div element="sect1" href="tdddg_intro003.htm" number="1.3" targetptr="TDDDG11000"> <ttl>About Oracle Database</ttl> <xreftext>“About Oracle Database”</xreftext> <div element="sect2" href="tdddg_intro004.htm" number="1.3.1" targetptr="TDDDG11200"> <ttl>About Schema Objects</ttl> <xreftext>“About Schema Objects”</xreftext> </div> <div element="sect2" href="tdddg_intro005.htm" number="1.3.2" targetptr="TDDDG12000"> <ttl>About Oracle Database Access</ttl> <xreftext>“About Oracle Database Access”</xreftext> <div element="sect3" href="tdddg_intro006.htm" number="1.3.2.1" targetptr="TDDDG99968"> <ttl>About SQL*Plus</ttl> <xreftext>“About SQL*Plus”</xreftext> </div> <div element="sect3" href="tdddg_intro007.htm" number="1.3.2.2" targetptr="TDDDG99969"> <ttl>About SQL Developer</ttl> <xreftext>“About SQL Developer”</xreftext> </div> <div element="sect3" href="tdddg_intro008.htm" number="1.3.2.3" targetptr="TDDDG12100"> <ttl>About Structured Query Language (SQL)</ttl> <xreftext>“About Structured Query Language (SQL)”</xreftext> </div> <div element="sect3" href="tdddg_intro009.htm" number="1.3.2.4" targetptr="TDDDG99999"> <ttl>About Procedural Language/SQL (PL/SQL)</ttl> <xreftext>“About Procedural Language/SQL (PL/SQL)”</xreftext> </div> <div element="sect3" href="tdddg_intro010.htm" number="1.3.2.5" targetptr="TDDDG13000"> <ttl>About Other Client Programs, Languages, and Development Tools</ttl> <xreftext>“About Other Client Programs, Languages, and Development Tools”</xreftext> <div element="sect4" href="tdddg_intro011.htm" number="1.3.2.5.1" targetptr="TDDDG108"> <ttl>Oracle Application Express (APEX)</ttl> <xreftext>“Oracle Application Express (APEX)”</xreftext> </div> <div element="sect4" href="tdddg_intro012.htm" number="1.3.2.5.2" targetptr="TDDDG109"> <ttl>Oracle Java Database Connectivity (JDBC)</ttl> <xreftext>“Oracle Java Database Connectivity (JDBC)”</xreftext> </div> <div element="sect4" href="tdddg_intro013.htm" number="1.3.2.5.3" targetptr="TDDDG110"> <ttl>Hypertext Preprocessor (PHP)</ttl> <xreftext>“Hypertext Preprocessor (PHP)”</xreftext> </div> <div element="sect4" href="tdddg_intro014.htm" number="1.3.2.5.4" targetptr="TDDDG111"> <ttl>Oracle Call Interface (OCI)</ttl> <xreftext>“Oracle Call Interface (OCI)”</xreftext> </div> <div element="sect4" href="tdddg_intro015.htm" number="1.3.2.5.5" targetptr="TDDDG112"> <ttl>Oracle C++ Call Interface (OCCI)</ttl> <xreftext>“Oracle C++ Call Interface (OCCI)”</xreftext> </div> <div element="sect4" href="tdddg_intro016.htm" number="1.3.2.5.6" targetptr="TDDDG113"> <ttl>Open Database Connectivity (ODBC)</ttl> <xreftext>“Open Database Connectivity (ODBC)”</xreftext> </div> <div element="sect4" href="tdddg_intro017.htm" number="1.3.2.5.7" targetptr="TDDDG114"> <ttl>Pro*C/C++ Precompiler</ttl> <xreftext>“Pro*C/C++ Precompiler”</xreftext> </div> <div element="sect4" href="tdddg_intro018.htm" number="1.3.2.5.8" targetptr="TDDDG115"> <ttl>Pro*COBOL Precompiler</ttl> <xreftext>“Pro*COBOL Precompiler”</xreftext> </div> <div element="sect4" href="tdddg_intro019.htm" number="1.3.2.5.9" targetptr="TDDDG116"> <ttl>Microsoft .NET Framework</ttl> <xreftext>“Microsoft .NET Framework”</xreftext> </div> <div element="sect4" href="tdddg_intro020.htm" number="1.3.2.5.10" targetptr="TDDDG117"> <ttl>Oracle Provider for OLE DB (OraOLEDB)</ttl> <xreftext>“Oracle Provider for OLE DB (OraOLEDB)”</xreftext> </div> <div element="sect4" href="tdddg_intro021.htm" number="1.3.2.5.11" targetptr="TDDDG118"> <ttl>Oracle Objects for OLE (OO4O)</ttl> <xreftext>“Oracle Objects for OLE (OO4O)”</xreftext> </div> </div> </div> </div> <div element="sect1" href="tdddg_intro022.htm" number="1.4" targetptr="TDDDG12400"> <ttl>About Sample Schema HR</ttl> <xreftext>“About Sample Schema HR”</xreftext> </div> </div> <div element="chapter" href="tdddg_connecting.htm" number="2" targetptr="TDDDG99998"> <ttl>Connecting to Oracle Database</ttl> <xreftext>“Connecting to Oracle Database”</xreftext> <div element="sect1" href="tdddg_connecting001.htm" number="2.1" targetptr="TDDDG12300"> <ttl>Connecting to Oracle Database from SQL*Plus</ttl> <xreftext>“Connecting to Oracle Database from SQL*Plus”</xreftext> <obj element="bridgehead" href="tdddg_connecting001.htm" number="" targetptr="TDDDG119"> <ttl>To connect to Oracle Database from SQL*Plus:</ttl> <xreftext>“To connect to Oracle Database from SQL*Plus:”</xreftext> </obj> <obj element="example" href="tdddg_connecting001.htm" number="2-1" targetptr="CEGHFHIG"> <ttl>Connecting to Oracle Database from SQL*Plus</ttl> <xreftext>“Connecting to Oracle Database from SQL*Plus”</xreftext> </obj> </div> <div element="sect1" href="tdddg_connecting002.htm" number="2.2" targetptr="TDDDG12200"> <ttl>Connecting to Oracle Database from SQL Developer</ttl> <xreftext>“Connecting to Oracle Database from SQL Developer”</xreftext> <obj element="bridgehead" href="tdddg_connecting002.htm" number="" targetptr="TDDDG121"> <ttl>To connect to Oracle Database from SQL Developer:</ttl> <xreftext>“To connect to Oracle Database from SQL Developer:”</xreftext> </obj> </div> <div element="sect1" href="tdddg_connecting003.htm" number="2.3" targetptr="TDDDG12500"> <ttl>Connecting to Oracle Database as User HR</ttl> <xreftext>“Connecting to Oracle Database as User HR”</xreftext> <div element="sect2" href="tdddg_connecting004.htm" number="2.3.1" targetptr="TDDDG12510"> <ttl>Unlocking the HR Account</ttl> <xreftext>“Unlocking the HR Account”</xreftext> <obj element="bridgehead" href="tdddg_connecting004.htm" number="" targetptr="TDDDG122"> <ttl>To unlock the HR account and reset its password:</ttl> <xreftext>“To unlock the HR account and reset its password:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_connecting005.htm" number="2.3.2" targetptr="TDDDG12520"> <ttl>Connecting to Oracle Database as User HR from SQL*Plus</ttl> <xreftext>“Connecting to Oracle Database as User HR from SQL*Plus”</xreftext> <obj element="bridgehead" href="tdddg_connecting005.htm" number="" targetptr="TDDDG123"> <ttl>To connect to Oracle Database as user HR from SQL*Plus:</ttl> <xreftext>“To connect to Oracle Database as user HR from SQL*Plus:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_connecting006.htm" number="2.3.3" targetptr="TDDDG12530"> <ttl>Connecting to Oracle Database as User HR from SQL Developer</ttl> <xreftext>“Connecting to Oracle Database as User HR from SQL Developer”</xreftext> <obj element="bridgehead" href="tdddg_connecting006.htm" number="" targetptr="TDDDG124"> <ttl>To connect to Oracle Database as user HR from SQL Developer:</ttl> <xreftext>“To connect to Oracle Database as user HR from SQL Developer:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="tdddg_exploring.htm" number="3" targetptr="TDDDG99996"> <ttl>Exploring Oracle Database with SQL Developer</ttl> <xreftext>“Exploring Oracle Database with SQL Developer”</xreftext> <div element="sect1" href="tdddg_exploring001.htm" number="3.1" targetptr="TDDDG21200"> <ttl>Tutorial: Viewing HR Schema Objects</ttl> <xreftext>“Tutorial: Viewing HR Schema Objects”</xreftext> <obj element="bridgehead" href="tdddg_exploring001.htm" number="" targetptr="TDDDG125"> <ttl>To browse the HR schema:</ttl> <xreftext>“To browse the HR schema:”</xreftext> </obj> </div> <div element="sect1" href="tdddg_exploring002.htm" number="3.2" targetptr="TDDDG21100"> <ttl>Tutorial: Viewing EMPLOYEES Table Properties and Data</ttl> <xreftext>“Tutorial: Viewing EMPLOYEES Table Properties and Data”</xreftext> <obj element="bridgehead" href="tdddg_exploring002.htm" number="" targetptr="TDDDG126"> <ttl>To view the properties and data of the EMPLOYEES table:</ttl> <xreftext>“To view the properties and data of the EMPLOYEES table:”</xreftext> </obj> </div> </div> <div element="chapter" href="tdddg_selecting.htm" number="4" targetptr="TDDDG20000"> <ttl>Selecting Table Data</ttl> <xreftext>“Selecting Table Data”</xreftext> <div element="sect1" href="tdddg_selecting001.htm" number="4.1" targetptr="TDDDG22000"> <ttl>About Queries</ttl> <xreftext>“About Queries”</xreftext> </div> <div element="sect1" href="tdddg_selecting002.htm" number="4.2" targetptr="TDDDG22600"> <ttl>Running Queries in SQL Developer</ttl> <xreftext>“Running Queries in SQL Developer”</xreftext> <obj element="bridgehead" href="tdddg_selecting002.htm" number="" targetptr="TDDDG127"> <ttl>To run queries in SQL Developer:</ttl> <xreftext>“To run queries in SQL Developer:”</xreftext> </obj> </div> <div element="sect1" href="tdddg_selecting003.htm" number="4.3" targetptr="TDDDG99997"> <ttl>Tutorial: Selecting All Columns of a Table</ttl> <xreftext>“Tutorial: Selecting All Columns of a Table”</xreftext> <obj element="bridgehead" href="tdddg_selecting003.htm" number="" targetptr="TDDDG128"> <ttl>To select all columns of the EMPLOYEES Table:</ttl> <xreftext>“To select all columns of the EMPLOYEES Table:”</xreftext> </obj> </div> <div element="sect1" href="tdddg_selecting004.htm" number="4.4" targetptr="TDDDG99962"> <ttl>Tutorial: Selecting Specific Columns of a Table</ttl> <xreftext>“Tutorial: Selecting Specific Columns of a Table”</xreftext> <obj element="bridgehead" href="tdddg_selecting004.htm" number="" targetptr="TDDDG129"> <ttl>To select only FIRST_NAME, LAST_NAME, and DEPARTMENT_ID:</ttl> <xreftext>“To select only FIRST_NAME, LAST_NAME, and DEPARTMENT_ID:”</xreftext> </obj> </div> <div element="sect1" href="tdddg_selecting005.htm" number="4.5" targetptr="TDDDG22100"> <ttl>Displaying Selected Columns Under New Headings</ttl> <xreftext>“Displaying Selected Columns Under New Headings”</xreftext> <obj element="example" href="tdddg_selecting005.htm" number="4-1" targetptr="TDDDG130"> <ttl>Displaying Selected Columns Under New Headings</ttl> <xreftext>“Displaying Selected Columns Under New Headings”</xreftext> </obj> <obj element="example" href="tdddg_selecting005.htm" number="4-2" targetptr="TDDDG131"> <ttl>Preserving Case and Including Spaces in Column Aliases</ttl> <xreftext>“Preserving Case and Including Spaces in Column Aliases”</xreftext> </obj> </div> <div element="sect1" href="tdddg_selecting006.htm" number="4.6" targetptr="TDDDG22200"> <ttl>Selecting Data that Satisfies Specified Conditions</ttl> <xreftext>“Selecting Data that Satisfies Specified Conditions”</xreftext> <obj element="example" href="tdddg_selecting006.htm" number="4-3" targetptr="TDDDG132"> <ttl>Selecting Data from One Department</ttl> <xreftext>“Selecting Data from One Department”</xreftext> </obj> <obj element="example" href="tdddg_selecting006.htm" number="4-4" targetptr="TDDDG133"> <ttl>Selecting Data from Specified Departments</ttl> <xreftext>“Selecting Data from Specified Departments”</xreftext> </obj> <obj element="example" href="tdddg_selecting006.htm" number="4-5" targetptr="TDDDG134"> <ttl>Selecting Data for Last Names that Start with the Same Substring</ttl> <xreftext>“Selecting Data for Last Names that Start with the Same Substring”</xreftext> </obj> <obj element="example" href="tdddg_selecting006.htm" number="4-6" targetptr="TDDDG135"> <ttl>Selecting Data for Last Names that Include the Same Substring</ttl> <xreftext>“Selecting Data for Last Names that Include the Same Substring”</xreftext> </obj> <obj element="example" href="tdddg_selecting006.htm" number="4-7" targetptr="TDDDG136"> <ttl>Selecting Data that Satisfies Two Conditions</ttl> <xreftext>“Selecting Data that Satisfies Two Conditions”</xreftext> </obj> </div> <div element="sect1" href="tdddg_selecting007.htm" number="4.7" targetptr="TDDDG22300"> <ttl>Specifying Conditions with Regular Expressions</ttl> <xreftext>“Specifying Conditions with Regular Expressions”</xreftext> <obj element="example" href="tdddg_selecting007.htm" number="4-8" targetptr="TDDDG137"> <ttl>Selecting All Managers in the EMPLOYEES Table</ttl> <xreftext>“Selecting All Managers in the EMPLOYEES Table”</xreftext> </obj> <obj element="example" href="tdddg_selecting007.htm" number="4-9" targetptr="TDDDG138"> <ttl>Selecting All Employees Whose Last Names Have Double Vowels</ttl> <xreftext>“Selecting All Employees Whose Last Names Have Double Vowels”</xreftext> </obj> <obj element="example" href="tdddg_selecting007.htm" number="4-10" targetptr="TDDDG139"> <ttl>Displaying Phone Numbers in a Different Format</ttl> <xreftext>“Displaying Phone Numbers in a Different Format”</xreftext> </obj> <obj element="example" href="tdddg_selecting007.htm" number="4-11" targetptr="TDDDG140"> <ttl>Extracting the Street Number from Each STREET_ADDRESS</ttl> <xreftext>“Extracting the Street Number from Each STREET_ADDRESS”</xreftext> </obj> <obj element="example" href="tdddg_selecting007.htm" number="4-12" targetptr="TDDDG141"> <ttl>Counting the Number of Spaces in Each STREET_ADDRESS</ttl> <xreftext>“Counting the Number of Spaces in Each STREET_ADDRESS”</xreftext> </obj> <obj element="example" href="tdddg_selecting007.htm" number="4-13" targetptr="TDDDG142"> <ttl>Reporting the Position of the First Space in Each STREET_ADDRESS</ttl> <xreftext>“Reporting the Position of the First Space in Each STREET_ADDRESS”</xreftext> </obj> </div> <div element="sect1" href="tdddg_selecting008.htm" number="4.8" targetptr="TDDDG22400"> <ttl>Sorting Selected Data</ttl> <xreftext>“Sorting Selected Data”</xreftext> <obj element="example" href="tdddg_selecting008.htm" number="4-14" targetptr="TDDDG143"> <ttl>Sorting Selected Data by LAST_NAME</ttl> <xreftext>“Sorting Selected Data by LAST_NAME”</xreftext> </obj> <obj element="example" href="tdddg_selecting008.htm" number="4-15" targetptr="TDDDG144"> <ttl>Sorting Selected Data by an Unselected Column</ttl> <xreftext>“Sorting Selected Data by an Unselected Column”</xreftext> </obj> </div> <div element="sect1" href="tdddg_selecting009.htm" number="4.9" targetptr="TDDDG99961"> <ttl>Selecting Data from Multiple Tables</ttl> <xreftext>“Selecting Data from Multiple Tables”</xreftext> <obj element="example" href="tdddg_selecting009.htm" number="4-16" targetptr="TDDDG145"> <ttl>Selecting Data from Two Tables (Joining Two Tables)</ttl> <xreftext>“Selecting Data from Two Tables (Joining Two Tables)”</xreftext> </obj> </div> <div element="sect1" href="tdddg_selecting010.htm" number="4.10" targetptr="TDDDG22500"> <ttl>Using Operators and Functions in Queries</ttl> <xreftext>“Using Operators and Functions in Queries”</xreftext> <div element="sect2" href="tdddg_selecting011.htm" number="4.10.1" targetptr="TDDDG22510"> <ttl>Using Arithmetic Operators in Queries</ttl> <xreftext>“Using Arithmetic Operators in Queries”</xreftext> <obj element="example" href="tdddg_selecting011.htm" number="4-17" targetptr="TDDDG146"> <ttl>Using an Arithmetic Expression in a Query</ttl> <xreftext>“Using an Arithmetic Expression in a Query”</xreftext> </obj> </div> <div element="sect2" href="tdddg_selecting012.htm" number="4.10.2" targetptr="TDDDG22520"> <ttl>Using Numeric Functions in Queries</ttl> <xreftext>“Using Numeric Functions in Queries”</xreftext> <obj element="example" href="tdddg_selecting012.htm" number="4-18" targetptr="TDDDG147"> <ttl>Rounding Numeric Data</ttl> <xreftext>“Rounding Numeric Data”</xreftext> </obj> <obj element="example" href="tdddg_selecting012.htm" number="4-19" targetptr="TDDDG148"> <ttl>Truncating Numeric Data</ttl> <xreftext>“Truncating Numeric Data”</xreftext> </obj> </div> <div element="sect2" href="tdddg_selecting013.htm" number="4.10.3" targetptr="TDDDG99995"> <ttl>Using the Concatenation Operator in Queries</ttl> <xreftext>“Using the Concatenation Operator in Queries”</xreftext> <obj element="example" href="tdddg_selecting013.htm" number="4-20" targetptr="TDDDG149"> <ttl>Concatenating Character Data</ttl> <xreftext>“Concatenating Character Data”</xreftext> </obj> </div> <div element="sect2" href="tdddg_selecting014.htm" number="4.10.4" targetptr="TDDDG22530"> <ttl>Using Character Functions in Queries</ttl> <xreftext>“Using Character Functions in Queries”</xreftext> <obj element="example" href="tdddg_selecting014.htm" number="4-21" targetptr="TDDDG150"> <ttl>Changing the Case of Character Data</ttl> <xreftext>“Changing the Case of Character Data”</xreftext> </obj> <obj element="example" href="tdddg_selecting014.htm" number="4-22" targetptr="TDDDG151"> <ttl>Trimming Character Data</ttl> <xreftext>“Trimming Character Data”</xreftext> </obj> <obj element="example" href="tdddg_selecting014.htm" number="4-23" targetptr="TDDDG152"> <ttl>Padding Character Data</ttl> <xreftext>“Padding Character Data”</xreftext> </obj> <obj element="example" href="tdddg_selecting014.htm" number="4-24" targetptr="TDDDG153"> <ttl>Extracting Substrings from Character Data</ttl> <xreftext>“Extracting Substrings from Character Data”</xreftext> </obj> <obj element="example" href="tdddg_selecting014.htm" number="4-25" targetptr="TDDDG154"> <ttl>Replacing Substrings in Character Data</ttl> <xreftext>“Replacing Substrings in Character Data”</xreftext> </obj> </div> <div element="sect2" href="tdddg_selecting015.htm" number="4.10.5" targetptr="TDDDG22540"> <ttl>Using Datetime Functions in Queries</ttl> <xreftext>“Using Datetime Functions in Queries”</xreftext> <obj element="example" href="tdddg_selecting015.htm" number="4-26" targetptr="TDDDG155"> <ttl>Displaying the Number of Months Between Dates</ttl> <xreftext>“Displaying the Number of Months Between Dates”</xreftext> </obj> <obj element="example" href="tdddg_selecting015.htm" number="4-27" targetptr="TDDDG156"> <ttl>Displaying the Number of Years Between Dates</ttl> <xreftext>“Displaying the Number of Years Between Dates”</xreftext> </obj> <obj element="example" href="tdddg_selecting015.htm" number="4-28" targetptr="TDDDG157"> <ttl>Displaying the Last Day of a Selected Month</ttl> <xreftext>“Displaying the Last Day of a Selected Month”</xreftext> </obj> <obj element="example" href="tdddg_selecting015.htm" number="4-29" targetptr="TDDDG158"> <ttl>Displaying a Date Six Months from a Selected Date</ttl> <xreftext>“Displaying a Date Six Months from a Selected Date”</xreftext> </obj> <obj element="example" href="tdddg_selecting015.htm" number="4-30" targetptr="TDDDG159"> <ttl>Displaying System Date and Time</ttl> <xreftext>“Displaying System Date and Time”</xreftext> </obj> </div> <div element="sect2" href="tdddg_selecting016.htm" number="4.10.6" targetptr="TDDDG22550"> <ttl>Using Conversion Functions in Queries</ttl> <xreftext>“Using Conversion Functions in Queries”</xreftext> <obj element="example" href="tdddg_selecting016.htm" number="4-31" targetptr="TDDDG160"> <ttl>Converting Dates to Characters Using a Format Template</ttl> <xreftext>“Converting Dates to Characters Using a Format Template”</xreftext> </obj> <obj element="example" href="tdddg_selecting016.htm" number="4-32" targetptr="TDDDG161"> <ttl>Converting Dates to Characters Using Standard Formats</ttl> <xreftext>“Converting Dates to Characters Using Standard Formats”</xreftext> </obj> <obj element="example" href="tdddg_selecting016.htm" number="4-33" targetptr="TDDDG162"> <ttl>Converting Numbers to Characters Using a Format Template</ttl> <xreftext>“Converting Numbers to Characters Using a Format Template”</xreftext> </obj> <obj element="example" href="tdddg_selecting016.htm" number="4-34" targetptr="TDDDG163"> <ttl>Converting Characters to Numbers</ttl> <xreftext>“Converting Characters to Numbers”</xreftext> </obj> <obj element="example" href="tdddg_selecting016.htm" number="4-35" targetptr="TDDDG164"> <ttl>Converting a Character String to a Date</ttl> <xreftext>“Converting a Character String to a Date”</xreftext> </obj> <obj element="example" href="tdddg_selecting016.htm" number="4-36" targetptr="TDDDG165"> <ttl>Converting a Character String to a Time Stamp</ttl> <xreftext>“Converting a Character String to a Time Stamp”</xreftext> </obj> </div> <div element="sect2" href="tdddg_selecting017.htm" number="4.10.7" targetptr="TDDDG22560"> <ttl>Using Aggregate Functions in Queries</ttl> <xreftext>“Using Aggregate Functions in Queries”</xreftext> <obj element="example" href="tdddg_selecting017.htm" number="4-37" targetptr="TDDDG166"> <ttl>Counting the Number of Rows in Each Group</ttl> <xreftext>“Counting the Number of Rows in Each Group”</xreftext> </obj> <obj element="example" href="tdddg_selecting017.htm" number="4-38" targetptr="TDDDG167"> <ttl>Counting the Number of Distinct Values in a Set</ttl> <xreftext>“Counting the Number of Distinct Values in a Set”</xreftext> </obj> <obj element="example" href="tdddg_selecting017.htm" number="4-39" targetptr="TDDDG168"> <ttl>Using Aggregate Functions for Statistical Information</ttl> <xreftext>“Using Aggregate Functions for Statistical Information”</xreftext> </obj> <obj element="example" href="tdddg_selecting017.htm" number="4-40" targetptr="TDDDG169"> <ttl>Limiting Aggregate Functions to Rows that Satisfy a Condition</ttl> <xreftext>“Limiting Aggregate Functions to Rows that Satisfy a Condition”</xreftext> </obj> <obj element="example" href="tdddg_selecting017.htm" number="4-41" targetptr="TDDDG170"> <ttl>Showing the Rank and Percentile of a Number Within a Group</ttl> <xreftext>“Showing the Rank and Percentile of a Number Within a Group”</xreftext> </obj> <obj element="example" href="tdddg_selecting017.htm" number="4-42" targetptr="TDDDG171"> <ttl>Showing the Dense Rank of a Number Within a Group</ttl> <xreftext>“Showing the Dense Rank of a Number Within a Group”</xreftext> </obj> </div> <div element="sect2" href="tdddg_selecting018.htm" number="4.10.8" targetptr="TDDDG22570"> <ttl>Using NULL-Related Functions in Queries</ttl> <xreftext>“Using NULL-Related Functions in Queries”</xreftext> <obj element="example" href="tdddg_selecting018.htm" number="4-43" targetptr="TDDDG172"> <ttl>Substituting a String for a NULL Value</ttl> <xreftext>“Substituting a String for a NULL Value”</xreftext> </obj> <obj element="example" href="tdddg_selecting018.htm" number="4-44" targetptr="TDDDG173"> <ttl>Specifying Different Expressions for NULL and Not NULL Values</ttl> <xreftext>“Specifying Different Expressions for NULL and Not NULL Values”</xreftext> </obj> </div> <div element="sect2" href="tdddg_selecting019.htm" number="4.10.9" targetptr="TDDDG22580"> <ttl>Using CASE Expressions in Queries</ttl> <xreftext>“Using CASE Expressions in Queries”</xreftext> <obj element="example" href="tdddg_selecting019.htm" number="4-45" targetptr="TDDDG174"> <ttl>Using a CASE Expression in a Query</ttl> <xreftext>“Using a CASE Expression in a Query”</xreftext> </obj> </div> <div element="sect2" href="tdddg_selecting020.htm" number="4.10.10" targetptr="TDDDG99971"> <ttl>Using the DECODE Function in Queries</ttl> <xreftext>“Using the DECODE Function in Queries”</xreftext> <obj element="example" href="tdddg_selecting020.htm" number="4-46" targetptr="TDDDG175"> <ttl>Using the DECODE Function in a Query</ttl> <xreftext>“Using the DECODE Function in a Query”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="tdddg_dml.htm" number="5" targetptr="TDDDG99941"> <ttl>About DML Statements and Transactions</ttl> <xreftext>“About DML Statements and Transactions”</xreftext> <div element="sect1" href="tdddg_dml001.htm" number="5.1" targetptr="TDDDG23000"> <ttl>About Data Manipulation Language (DML) Statements</ttl> <xreftext>“About Data Manipulation Language (DML) Statements”</xreftext> <div element="sect2" href="tdddg_dml002.htm" number="5.1.1" targetptr="TDDDG23100"> <ttl>About the INSERT Statement</ttl> <xreftext>“About the INSERT Statement”</xreftext> <obj element="example" href="tdddg_dml002.htm" number="5-1" targetptr="TDDDG176"> <ttl>Using the INSERT Statement When All Information Is Available</ttl> <xreftext>“Using the INSERT Statement When All Information Is Available”</xreftext> </obj> <obj element="example" href="tdddg_dml002.htm" number="5-2" targetptr="TDDDG177"> <ttl>Using the INSERT Statement When Not All Information Is Available</ttl> <xreftext>“Using the INSERT Statement When Not All Information Is Available”</xreftext> </obj> <obj element="example" href="tdddg_dml002.htm" number="5-3" targetptr="TDDDG178"> <ttl>Using the INSERT Statement Incorrectly</ttl> <xreftext>“Using the INSERT Statement Incorrectly”</xreftext> </obj> </div> <div element="sect2" href="tdddg_dml003.htm" number="5.1.2" targetptr="TDDDG23200"> <ttl>About the UPDATE Statement</ttl> <xreftext>“About the UPDATE Statement”</xreftext> <obj element="example" href="tdddg_dml003.htm" number="5-4" targetptr="TDDDG179"> <ttl>Using the UPDATE Statement to Add Data</ttl> <xreftext>“Using the UPDATE Statement to Add Data”</xreftext> </obj> <obj element="example" href="tdddg_dml003.htm" number="5-5" targetptr="TDDDG180"> <ttl>Using the UPDATE Statement to Update Multiple Rows</ttl> <xreftext>“Using the UPDATE Statement to Update Multiple Rows”</xreftext> </obj> </div> <div element="sect2" href="tdddg_dml004.htm" number="5.1.3" targetptr="TDDDG23300"> <ttl>About the DELETE Statement</ttl> <xreftext>“About the DELETE Statement”</xreftext> <obj element="example" href="tdddg_dml004.htm" number="5-6" targetptr="TDDDG181"> <ttl>Using the DELETE Statement</ttl> <xreftext>“Using the DELETE Statement”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_dml005.htm" number="5.2" targetptr="TDDDG24000"> <ttl>About Transaction Control Statements</ttl> <xreftext>“About Transaction Control Statements”</xreftext> </div> <div element="sect1" href="tdddg_dml006.htm" number="5.3" targetptr="TDDDG24100"> <ttl>Committing Transactions</ttl> <xreftext>“Committing Transactions”</xreftext> <obj element="example" href="tdddg_dml006.htm" number="5-7" targetptr="TDDDG182"> <ttl>Committing a Transaction</ttl> <xreftext>“Committing a Transaction”</xreftext> </obj> </div> <div element="sect1" href="tdddg_dml007.htm" number="5.4" targetptr="TDDDG24200"> <ttl>Rolling Back Transactions</ttl> <xreftext>“Rolling Back Transactions”</xreftext> <obj element="example" href="tdddg_dml007.htm" number="5-8" targetptr="TDDDG183"> <ttl>Rolling Back an Entire Transaction</ttl> <xreftext>“Rolling Back an Entire Transaction”</xreftext> </obj> </div> <div element="sect1" href="tdddg_dml008.htm" number="5.5" targetptr="TDDDG24300"> <ttl>Setting Savepoints in Transactions</ttl> <xreftext>“Setting Savepoints in Transactions”</xreftext> <obj element="example" href="tdddg_dml008.htm" number="5-9" targetptr="TDDDG184"> <ttl>Rolling Back a Transaction to a Savepoint</ttl> <xreftext>“Rolling Back a Transaction to a Savepoint”</xreftext> </obj> </div> </div> <div element="chapter" href="tdddg_objects.htm" number="6" targetptr="TDDDG30000"> <ttl>Creating and Managing Schema Objects</ttl> <xreftext>“Creating and Managing Schema Objects”</xreftext> <div element="sect1" href="tdddg_objects001.htm" number="6.1" targetptr="TDDDG99994"> <ttl>About Data Definition Language (DDL) Statements</ttl> <xreftext>“About Data Definition Language (DDL) Statements”</xreftext> </div> <div element="sect1" href="tdddg_objects002.htm" number="6.2" targetptr="TDDDG99963"> <ttl>About Schema Object Names</ttl> <xreftext>“About Schema Object Names”</xreftext> </div> <div element="sect1" href="tdddg_objects003.htm" number="6.3" targetptr="TDDDG32000"> <ttl>Creating and Managing Tables</ttl> <xreftext>“Creating and Managing Tables”</xreftext> <div element="sect2" href="tdddg_objects004.htm" number="6.3.1" targetptr="TDDDG31000"> <ttl>About SQL Data Types</ttl> <xreftext>“About SQL Data Types”</xreftext> </div> <div element="sect2" href="tdddg_objects005.htm" number="6.3.2" targetptr="TDDDG32100"> <ttl>Creating Tables</ttl> <xreftext>“Creating Tables”</xreftext> <div element="sect3" href="tdddg_objects006.htm" number="6.3.2.1" targetptr="TDDDG185"> <ttl>Tutorial: Creating a Table with the Create Table Tool</ttl> <xreftext>“Tutorial: Creating a Table with the Create Table Tool”</xreftext> <obj element="bridgehead" href="tdddg_objects006.htm" number="" targetptr="TDDDG186"> <ttl>To create the PERFORMANCE_PARTS table using the Create Table tool:</ttl> <xreftext>“To create the PERFORMANCE_PARTS table using the Create Table tool:”</xreftext> </obj> </div> <div element="sect3" href="tdddg_objects007.htm" number="6.3.2.2" targetptr="TDDDG187"> <ttl>Creating Tables with the CREATE TABLE Statement</ttl> <xreftext>“Creating Tables with the CREATE TABLE Statement”</xreftext> <obj element="example" href="tdddg_objects007.htm" number="6-1" targetptr="TDDDG188"> <ttl>Creating the EVALUATIONS Table with CREATE TABLE</ttl> <xreftext>“Creating the EVALUATIONS Table with CREATE TABLE”</xreftext> </obj> <obj element="example" href="tdddg_objects007.htm" number="6-2" targetptr="TDDDG189"> <ttl>Creating the SCORES Table with CREATE TABLE</ttl> <xreftext>“Creating the SCORES Table with CREATE TABLE”</xreftext> </obj> </div> </div> <div element="sect2" href="tdddg_objects008.htm" number="6.3.3" targetptr="TDDDG32200"> <ttl>Ensuring Data Integrity in Tables</ttl> <xreftext>“Ensuring Data Integrity in Tables”</xreftext> <div element="sect3" href="tdddg_objects009.htm" number="6.3.3.1" targetptr="TDDDG32210"> <ttl>About Constraint Types</ttl> <xreftext>“About Constraint Types”</xreftext> </div> <div element="sect3" href="tdddg_objects010.htm" number="6.3.3.2" targetptr="TDDDG32220"> <ttl>Tutorial: Adding Constraints to Existing Tables</ttl> <xreftext>“Tutorial: Adding Constraints to Existing Tables”</xreftext> <obj element="bridgehead" href="tdddg_objects010.htm" number="" targetptr="TDDDG190"> <ttl>To add a Not Null constraint using the Edit Table tool:</ttl> <xreftext>“To add a Not Null constraint using the Edit Table tool:”</xreftext> </obj> <obj element="bridgehead" href="tdddg_objects010.htm" number="" targetptr="TDDDG191"> <ttl>To add a Not Null constraint using the ALTER TABLE statement:</ttl> <xreftext>“To add a Not Null constraint using the ALTER TABLE statement:”</xreftext> </obj> <obj element="bridgehead" href="tdddg_objects010.htm" number="" targetptr="TDDDG192"> <ttl>To add a Unique constraint using the Add Unique tool:</ttl> <xreftext>“To add a Unique constraint using the Add Unique tool:”</xreftext> </obj> <obj element="bridgehead" href="tdddg_objects010.htm" number="" targetptr="TDDDG193"> <ttl>To add a Primary Key constraint using the Add Primary Key tool:</ttl> <xreftext>“To add a Primary Key constraint using the Add Primary Key tool:”</xreftext> </obj> <obj element="bridgehead" href="tdddg_objects010.htm" number="" targetptr="TDDDG194"> <ttl>To add a Primary Key constraint using the ALTER TABLE statement:</ttl> <xreftext>“To add a Primary Key constraint using the ALTER TABLE statement:”</xreftext> </obj> <obj element="bridgehead" href="tdddg_objects010.htm" number="" targetptr="TDDDG195"> <ttl>To add two Foreign Key constraints using the Add Foreign Key tool:</ttl> <xreftext>“To add two Foreign Key constraints using the Add Foreign Key tool:”</xreftext> </obj> <obj element="bridgehead" href="tdddg_objects010.htm" number="" targetptr="TDDDG196"> <ttl>To add a Foreign Key constraint using the ALTER TABLE statement:</ttl> <xreftext>“To add a Foreign Key constraint using the ALTER TABLE statement:”</xreftext> </obj> <obj element="bridgehead" href="tdddg_objects010.htm" number="" targetptr="TDDDG197"> <ttl>To add a Check constraint using the Add Check tool:</ttl> <xreftext>“To add a Check constraint using the Add Check tool:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdddg_objects011.htm" number="6.3.4" targetptr="TDDDG32300"> <ttl>Tutorial: Adding Rows to Tables with the Insert Row Tool</ttl> <xreftext>“Tutorial: Adding Rows to Tables with the Insert Row Tool”</xreftext> <obj element="bridgehead" href="tdddg_objects011.htm" number="" targetptr="TDDDG198"> <ttl>To add rows to the PERFORMANCE_PARTS table using the Insert Row tool:</ttl> <xreftext>“To add rows to the PERFORMANCE_PARTS table using the Insert Row tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_objects012.htm" number="6.3.5" targetptr="TDDDG99990"> <ttl>Tutorial: Changing Data in Tables in the Data Pane</ttl> <xreftext>“Tutorial: Changing Data in Tables in the Data Pane”</xreftext> <obj element="bridgehead" href="tdddg_objects012.htm" number="" targetptr="TDDDG199"> <ttl>To change data in the PERFORMANCE_PARTS table using the Data pane:</ttl> <xreftext>“To change data in the PERFORMANCE_PARTS table using the Data pane:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_objects013.htm" number="6.3.6" targetptr="TDDDG99989"> <ttl>Tutorial: Deleting Rows from Tables with the Delete Selected Row(s) Tool</ttl> <xreftext>“Tutorial: Deleting Rows from Tables with the Delete Selected Row(s) Tool”</xreftext> <obj element="bridgehead" href="tdddg_objects013.htm" number="" targetptr="TDDDG200"> <ttl>To delete row from PERFORMANCE_PARTS using Delete Selected Row(s) tool:</ttl> <xreftext>“To delete row from PERFORMANCE_PARTS using Delete Selected Row(s) tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_objects014.htm" number="6.3.7" targetptr="TDDDG32400"> <ttl>Managing Indexes</ttl> <xreftext>“Managing Indexes”</xreftext> <div element="sect3" href="tdddg_objects015.htm" number="6.3.7.1" targetptr="TDDDG99979"> <ttl>Tutorial: Adding an Index with the Create Index Tool</ttl> <xreftext>“Tutorial: Adding an Index with the Create Index Tool”</xreftext> <obj element="bridgehead" href="tdddg_objects015.htm" number="" targetptr="TDDDG201"> <ttl>To add an index to the EVALUATIONS table using the Create Index tool:</ttl> <xreftext>“To add an index to the EVALUATIONS table using the Create Index tool:”</xreftext> </obj> </div> <div element="sect3" href="tdddg_objects016.htm" number="6.3.7.2" targetptr="TDDDG99988"> <ttl>Tutorial: Changing an Index with the Edit Index Tool</ttl> <xreftext>“Tutorial: Changing an Index with the Edit Index Tool”</xreftext> <obj element="bridgehead" href="tdddg_objects016.htm" number="" targetptr="TDDDG202"> <ttl>To reverse the sort order of the index EVAL_JOB_IX using the Edit Index tool:</ttl> <xreftext>“To reverse the sort order of the index EVAL_JOB_IX using the Edit Index tool:”</xreftext> </obj> </div> <div element="sect3" href="tdddg_objects017.htm" number="6.3.7.3" targetptr="TDDDG99987"> <ttl>Tutorial: Dropping an Index</ttl> <xreftext>“Tutorial: Dropping an Index”</xreftext> <obj element="bridgehead" href="tdddg_objects017.htm" number="" targetptr="TDDDG203"> <ttl>To drop the index EVAL_JOB_IX:</ttl> <xreftext>“To drop the index EVAL_JOB_IX:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdddg_objects018.htm" number="6.3.8" targetptr="TDDDG32500"> <ttl>Dropping Tables</ttl> <xreftext>“Dropping Tables”</xreftext> <obj element="bridgehead" href="tdddg_objects018.htm" number="" targetptr="TDDDG204"> <ttl>To drop a table using the Drop tool:</ttl> <xreftext>“To drop a table using the Drop tool:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_objects019.htm" number="6.4" targetptr="TDDDG33000"> <ttl>Creating and Managing Views</ttl> <xreftext>“Creating and Managing Views”</xreftext> <div element="sect2" href="tdddg_objects020.htm" number="6.4.1" targetptr="TDDDG33100"> <ttl>Creating Views</ttl> <xreftext>“Creating Views”</xreftext> <div element="sect3" href="tdddg_objects021.htm" number="6.4.1.1" targetptr="TDDDG205"> <ttl>Tutorial: Creating a View with the Create View Tool</ttl> <xreftext>“Tutorial: Creating a View with the Create View Tool”</xreftext> <obj element="bridgehead" href="tdddg_objects021.htm" number="" targetptr="TDDDG206"> <ttl>To create the SALESFORCE view using the Create View tool:</ttl> <xreftext>“To create the SALESFORCE view using the Create View tool:”</xreftext> </obj> </div> <div element="sect3" href="tdddg_objects022.htm" number="6.4.1.2" targetptr="TDDDG207"> <ttl>Creating Views with the CREATE VIEW Statement</ttl> <xreftext>“Creating Views with the CREATE VIEW Statement”</xreftext> <obj element="example" href="tdddg_objects022.htm" number="6-3" targetptr="TDDDG208"> <ttl>Creating the EMP_LOCATIONS View with CREATE VIEW</ttl> <xreftext>“Creating the EMP_LOCATIONS View with CREATE VIEW”</xreftext> </obj> </div> </div> <div element="sect2" href="tdddg_objects023.htm" number="6.4.2" targetptr="TDDDG33200"> <ttl>Tutorial: Changing Views with the Edit View and Rename Tools</ttl> <xreftext>“Tutorial: Changing Views with the Edit View and Rename Tools”</xreftext> <obj element="bridgehead" href="tdddg_objects023.htm" number="" targetptr="TDDDG209"> <ttl>To change the SALESFORCE view using the Edit View and Rename tools:</ttl> <xreftext>“To change the SALESFORCE view using the Edit View and Rename tools:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_objects024.htm" number="6.4.3" targetptr="TDDDG33300"> <ttl>Dropping Views</ttl> <xreftext>“Dropping Views”</xreftext> <obj element="bridgehead" href="tdddg_objects024.htm" number="" targetptr="TDDDG210"> <ttl>To drop the view SALES_MARKETING using the Drop tool:</ttl> <xreftext>“To drop the view SALES_MARKETING using the Drop tool:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_objects025.htm" number="6.5" targetptr="TDDDG34000"> <ttl>Creating and Managing Sequences</ttl> <xreftext>“Creating and Managing Sequences”</xreftext> <div element="sect2" href="tdddg_objects026.htm" number="6.5.1" targetptr="TDDDG34100"> <ttl>Tutorial: Creating a Sequence</ttl> <xreftext>“Tutorial: Creating a Sequence”</xreftext> <obj element="bridgehead" href="tdddg_objects026.htm" number="" targetptr="TDDDG211"> <ttl>To create EVALUATIONS_SEQ using the Create Database Sequence tool:</ttl> <xreftext>“To create EVALUATIONS_SEQ using the Create Database Sequence tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_objects027.htm" number="6.5.2" targetptr="TDDDG34300"> <ttl>Dropping Sequences</ttl> <xreftext>“Dropping Sequences”</xreftext> <obj element="bridgehead" href="tdddg_objects027.htm" number="" targetptr="TDDDG212"> <ttl>To drop a sequence using the Drop tool:</ttl> <xreftext>“To drop a sequence using the Drop tool:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_objects028.htm" number="6.6" targetptr="TDDDG35000"> <ttl>Creating and Managing Synonyms</ttl> <xreftext>“Creating and Managing Synonyms”</xreftext> <div element="sect2" href="tdddg_objects029.htm" number="6.6.1" targetptr="TDDDG99986"> <ttl>Creating Synonyms</ttl> <xreftext>“Creating Synonyms”</xreftext> <obj element="bridgehead" href="tdddg_objects029.htm" number="" targetptr="TDDDG213"> <ttl>To create a synonym using the Create Databse Synonym tool:</ttl> <xreftext>“To create a synonym using the Create Databse Synonym tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_objects030.htm" number="6.6.2" targetptr="TDDDG99985"> <ttl>Dropping Synonyms</ttl> <xreftext>“Dropping Synonyms”</xreftext> <obj element="bridgehead" href="tdddg_objects030.htm" number="" targetptr="TDDDG214"> <ttl>To drop a synonym using the Drop tool:</ttl> <xreftext>“To drop a synonym using the Drop tool:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="tdddg_subprograms.htm" number="7" targetptr="TDDDG40000"> <ttl>Developing Stored Subprograms and Packages</ttl> <xreftext>“Developing Stored Subprograms and Packages”</xreftext> <div element="sect1" href="tdddg_subprograms001.htm" number="7.1" targetptr="TDDDG48000"> <ttl>About Stored Subprograms</ttl> <xreftext>“About Stored Subprograms”</xreftext> </div> <div element="sect1" href="tdddg_subprograms002.htm" number="7.2" targetptr="TDDDG99991"> <ttl>About Packages</ttl> <xreftext>“About Packages”</xreftext> </div> <div element="sect1" href="tdddg_subprograms003.htm" number="7.3" targetptr="TDDDG42210"> <ttl>About PL/SQL Identifiers</ttl> <xreftext>“About PL/SQL Identifiers”</xreftext> </div> <div element="sect1" href="tdddg_subprograms004.htm" number="7.4" targetptr="TDDDG42100"> <ttl>About PL/SQL Data Types</ttl> <xreftext>“About PL/SQL Data Types”</xreftext> </div> <div element="sect1" href="tdddg_subprograms005.htm" number="7.5" targetptr="TDDDG41000"> <ttl>Creating and Managing Standalone Stored Subprograms</ttl> <xreftext>“Creating and Managing Standalone Stored Subprograms”</xreftext> <div element="sect2" href="tdddg_subprograms006.htm" number="7.5.1" targetptr="TDDDG42205"> <ttl>About Subprogram Structure</ttl> <xreftext>“About Subprogram Structure”</xreftext> </div> <div element="sect2" href="tdddg_subprograms007.htm" number="7.5.2" targetptr="TDDDG99975"> <ttl>Tutorial: Creating a Standalone Stored Procedure</ttl> <xreftext>“Tutorial: Creating a Standalone Stored Procedure”</xreftext> <obj element="bridgehead" href="tdddg_subprograms007.htm" number="" targetptr="TDDDG215"> <ttl>To create a standalone stored procedure using Create PL/SQL Procedure tool:</ttl> <xreftext>“To create a standalone stored procedure using Create PL/SQL Procedure tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms008.htm" number="7.5.3" targetptr="TDDDG99984"> <ttl>Tutorial: Creating a Standalone Stored Function</ttl> <xreftext>“Tutorial: Creating a Standalone Stored Function”</xreftext> <obj element="bridgehead" href="tdddg_subprograms008.htm" number="" targetptr="TDDDG216"> <ttl>To create a standalone stored function using Create PL/SQL Function tool:</ttl> <xreftext>“To create a standalone stored function using Create PL/SQL Function tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms009.htm" number="7.5.4" targetptr="TDDDG41200"> <ttl>Changing Standalone Stored Subprograms</ttl> <xreftext>“Changing Standalone Stored Subprograms”</xreftext> <obj element="bridgehead" href="tdddg_subprograms009.htm" number="" targetptr="TDDDG217"> <ttl>To change a standalone stored subprogram using the Edit tool:</ttl> <xreftext>“To change a standalone stored subprogram using the Edit tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms010.htm" number="7.5.5" targetptr="TDDDG41400"> <ttl>Tutorial: Testing a Standalone Stored Function</ttl> <xreftext>“Tutorial: Testing a Standalone Stored Function”</xreftext> <obj element="bridgehead" href="tdddg_subprograms010.htm" number="" targetptr="TDDDG218"> <ttl>To test the calculate_score function using the Run tool:</ttl> <xreftext>“To test the calculate_score function using the Run tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms011.htm" number="7.5.6" targetptr="TDDDG41300"> <ttl>Dropping Standalone Stored Subprograms</ttl> <xreftext>“Dropping Standalone Stored Subprograms”</xreftext> <obj element="bridgehead" href="tdddg_subprograms011.htm" number="" targetptr="TDDDG219"> <ttl>To drop a standalone stored subprogram using the Drop tool:</ttl> <xreftext>“To drop a standalone stored subprogram using the Drop tool:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_subprograms012.htm" number="7.6" targetptr="TDDDG47000"> <ttl>Creating and Managing Packages</ttl> <xreftext>“Creating and Managing Packages”</xreftext> <div element="sect2" href="tdddg_subprograms013.htm" number="7.6.1" targetptr="TDDDG99993"> <ttl>About Package Structure</ttl> <xreftext>“About Package Structure”</xreftext> </div> <div element="sect2" href="tdddg_subprograms014.htm" number="7.6.2" targetptr="TDDDG47200"> <ttl>Tutorial: Creating a Package Specification</ttl> <xreftext>“Tutorial: Creating a Package Specification”</xreftext> <obj element="bridgehead" href="tdddg_subprograms014.htm" number="" targetptr="TDDDG220"> <ttl>To create a package specification using Create PL/SQL Package tool:</ttl> <xreftext>“To create a package specification using Create PL/SQL Package tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms015.htm" number="7.6.3" targetptr="TDDDG47300"> <ttl>Tutorial: Changing a Package Specification</ttl> <xreftext>“Tutorial: Changing a Package Specification”</xreftext> <obj element="bridgehead" href="tdddg_subprograms015.htm" number="" targetptr="TDDDG221"> <ttl>To change EMP_EVAL package specification using the Edit tool:</ttl> <xreftext>“To change EMP_EVAL package specification using the Edit tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms016.htm" number="7.6.4" targetptr="TDDDG99992"> <ttl>Tutorial: Creating a Package Body</ttl> <xreftext>“Tutorial: Creating a Package Body”</xreftext> <obj element="bridgehead" href="tdddg_subprograms016.htm" number="" targetptr="TDDDG222"> <ttl>To create a body for the package EMP_EVAL using the Create Body tool:</ttl> <xreftext>“To create a body for the package EMP_EVAL using the Create Body tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms017.htm" number="7.6.5" targetptr="TDDDG47400"> <ttl>Dropping a Package</ttl> <xreftext>“Dropping a Package”</xreftext> <obj element="bridgehead" href="tdddg_subprograms017.htm" number="" targetptr="TDDDG223"> <ttl>To drop a package using the Drop tool:</ttl> <xreftext>“To drop a package using the Drop tool:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_subprograms018.htm" number="7.7" targetptr="TDDDG42000"> <ttl>Declaring and Assigning Values to Variables and Constants</ttl> <xreftext>“Declaring and Assigning Values to Variables and Constants”</xreftext> <div element="sect2" href="tdddg_subprograms019.htm" number="7.7.1" targetptr="TDDDG42200"> <ttl>Tutorial: Declaring Variables and Constants in a Subprogram</ttl> <xreftext>“Tutorial: Declaring Variables and Constants in a Subprogram”</xreftext> <obj element="bridgehead" href="tdddg_subprograms019.htm" number="" targetptr="TDDDG224"> <ttl>To declare variables and constants in calculate_score function:</ttl> <xreftext>“To declare variables and constants in calculate_score function:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms020.htm" number="7.7.2" targetptr="TDDDG42220"> <ttl>Ensuring that Variables, Constants, and Parameters Have Correct Data Types</ttl> <xreftext>“Ensuring that Variables, Constants, and Parameters Have Correct Data Types”</xreftext> </div> <div element="sect2" href="tdddg_subprograms021.htm" number="7.7.3" targetptr="TDDDG99960"> <ttl>Tutorial: Changing Declarations to Use the %TYPE Attribute</ttl> <xreftext>“Tutorial: Changing Declarations to Use the %TYPE Attribute”</xreftext> <obj element="bridgehead" href="tdddg_subprograms021.htm" number="" targetptr="TDDDG225"> <ttl>To change the declarations in calculate_score to use %TYPE:</ttl> <xreftext>“To change the declarations in calculate_score to use %TYPE:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms022.htm" number="7.7.4" targetptr="TDDDG42300"> <ttl>Assigning Values to Variables</ttl> <xreftext>“Assigning Values to Variables”</xreftext> <div element="sect3" href="tdddg_subprograms023.htm" number="7.7.4.1" targetptr="TDDDG42320"> <ttl>Assigning Values to Variables with the Assignment Operator</ttl> <xreftext>“Assigning Values to Variables with the Assignment Operator”</xreftext> <obj element="example" href="tdddg_subprograms023.htm" number="7-1" targetptr="TDDDG226"> <ttl>Assigning Values to a Variable with Assignment Operator</ttl> <xreftext>“Assigning Values to a Variable with Assignment Operator”</xreftext> </obj> </div> <div element="sect3" href="tdddg_subprograms024.htm" number="7.7.4.2" targetptr="TDDDG42330"> <ttl>Assigning Values to Variables with the SELECT INTO Statement</ttl> <xreftext>“Assigning Values to Variables with the SELECT INTO Statement”</xreftext> <obj element="example" href="tdddg_subprograms024.htm" number="7-2" targetptr="TDDDG227"> <ttl>Assigning Table Values to Variables with SELECT INTO</ttl> <xreftext>“Assigning Table Values to Variables with SELECT INTO”</xreftext> </obj> <obj element="example" href="tdddg_subprograms024.htm" number="7-3" targetptr="TDDDG228"> <ttl>Inserting a Table Row with Values from Another Table</ttl> <xreftext>“Inserting a Table Row with Values from Another Table”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="tdddg_subprograms025.htm" number="7.8" targetptr="TDDDG44000"> <ttl>Controlling Program Flow</ttl> <xreftext>“Controlling Program Flow”</xreftext> <div element="sect2" href="tdddg_subprograms026.htm" number="7.8.1" targetptr="TDDDG99959"> <ttl>About Control Statements</ttl> <xreftext>“About Control Statements”</xreftext> </div> <div element="sect2" href="tdddg_subprograms027.htm" number="7.8.2" targetptr="TDDDG44110"> <ttl>Using the IF Statement</ttl> <xreftext>“Using the IF Statement”</xreftext> <obj element="example" href="tdddg_subprograms027.htm" number="7-4" targetptr="TDDDG229"> <ttl>IF Statement that Determines Return Value of Function</ttl> <xreftext>“IF Statement that Determines Return Value of Function”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms028.htm" number="7.8.3" targetptr="TDDDG44120"> <ttl>Using the CASE Statement</ttl> <xreftext>“Using the CASE Statement”</xreftext> <obj element="example" href="tdddg_subprograms028.htm" number="7-5" targetptr="TDDDG230"> <ttl>CASE Statement that Determines Which String to Print</ttl> <xreftext>“CASE Statement that Determines Which String to Print”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms029.htm" number="7.8.4" targetptr="TDDDG44210"> <ttl>Using the FOR LOOP Statement</ttl> <xreftext>“Using the FOR LOOP Statement”</xreftext> <obj element="example" href="tdddg_subprograms029.htm" number="7-6" targetptr="TDDDG231"> <ttl>FOR LOOP Statement that Computes Salary After Five Years</ttl> <xreftext>“FOR LOOP Statement that Computes Salary After Five Years”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms030.htm" number="7.8.5" targetptr="TDDDG44220"> <ttl>Using the WHILE LOOP Statement</ttl> <xreftext>“Using the WHILE LOOP Statement”</xreftext> <obj element="example" href="tdddg_subprograms030.htm" number="7-7" targetptr="TDDDG232"> <ttl>WHILE LOOP Statement that Computes Salary to Maximum</ttl> <xreftext>“WHILE LOOP Statement that Computes Salary to Maximum”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms031.htm" number="7.8.6" targetptr="TDDDG44230"> <ttl>Using the Basic LOOP and EXIT WHEN Statements</ttl> <xreftext>“Using the Basic LOOP and EXIT WHEN Statements”</xreftext> <obj element="example" href="tdddg_subprograms031.htm" number="7-8" targetptr="TDDDG233"> <ttl>Using the EXIT WHEN Statement</ttl> <xreftext>“Using the EXIT WHEN Statement”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_subprograms032.htm" number="7.9" targetptr="TDDDG43000"> <ttl>Using Records and Cursors</ttl> <xreftext>“Using Records and Cursors”</xreftext> <div element="sect2" href="tdddg_subprograms033.htm" number="7.9.1" targetptr="TDDDG99958"> <ttl>About Records</ttl> <xreftext>“About Records”</xreftext> </div> <div element="sect2" href="tdddg_subprograms034.htm" number="7.9.2" targetptr="TDDDG99957"> <ttl>Tutorial: Declaring a RECORD Type</ttl> <xreftext>“Tutorial: Declaring a RECORD Type”</xreftext> <obj element="bridgehead" href="tdddg_subprograms034.htm" number="" targetptr="TDDDG234"> <ttl>To declare RECORD type sal_info:</ttl> <xreftext>“To declare RECORD type sal_info:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms035.htm" number="7.9.3" targetptr="TDDDG99956"> <ttl>Tutorial: Creating and Invoking a Subprogram with a Record Parameter</ttl> <xreftext>“Tutorial: Creating and Invoking a Subprogram with a Record Parameter”</xreftext> <obj element="bridgehead" href="tdddg_subprograms035.htm" number="" targetptr="TDDDG235"> <ttl>To create salary_schedule and change eval_frequency:</ttl> <xreftext>“To create salary_schedule and change eval_frequency:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms036.htm" number="7.9.4" targetptr="TDDDG45000"> <ttl>About Cursors</ttl> <xreftext>“About Cursors”</xreftext> <obj element="table" href="tdddg_subprograms036.htm" number="7-1" targetptr="TDDDG236"> <ttl>Cursor Attribute Values</ttl> <xreftext>“Cursor Attribute Values”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms037.htm" number="7.9.5" targetptr="TDDDG46100"> <ttl>Using an Explicit Cursor to Retrieve Result Set Rows One at a Time</ttl> <xreftext>“Using an Explicit Cursor to Retrieve Result Set Rows One at a Time”</xreftext> <obj element="bridgehead" href="tdddg_subprograms037.htm" number="" targetptr="TDDDG237"> <ttl>To use an explicit cursor to retrieve result set rows one at a time:</ttl> <xreftext>“To use an explicit cursor to retrieve result set rows one at a time:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms038.htm" number="7.9.6" targetptr="TDDDG99953"> <ttl>Tutorial: Using an Explicit Cursor to Retrieve Result Set Rows One at a Time</ttl> <xreftext>“Tutorial: Using an Explicit Cursor to Retrieve Result Set Rows One at a Time”</xreftext> <obj element="bridgehead" href="tdddg_subprograms038.htm" number="" targetptr="TDDDG238"> <ttl>To implement the EMP_EVAL.eval_department procedure:</ttl> <xreftext>“To implement the EMP_EVAL.eval_department procedure:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms039.htm" number="7.9.7" targetptr="TDDDG99939"> <ttl>About Cursor Variables</ttl> <xreftext>“About Cursor Variables”</xreftext> </div> <div element="sect2" href="tdddg_subprograms040.htm" number="7.9.8" targetptr="TDDDG99954"> <ttl>Using a Cursor Variable to Retrieve Result Set Rows One at a Time</ttl> <xreftext>“Using a Cursor Variable to Retrieve Result Set Rows One at a Time”</xreftext> <obj element="bridgehead" href="tdddg_subprograms040.htm" number="" targetptr="TDDDG239"> <ttl>To use a cursor variable to retrieve result set rows one at a time:</ttl> <xreftext>“To use a cursor variable to retrieve result set rows one at a time:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms041.htm" number="7.9.9" targetptr="TDDDG99955"> <ttl>Tutorial: Using a Cursor Variable to Retrieve Result Set Rows One at a Time</ttl> <xreftext>“Tutorial: Using a Cursor Variable to Retrieve Result Set Rows One at a Time”</xreftext> <obj element="bridgehead" href="tdddg_subprograms041.htm" number="" targetptr="TDDDG240"> <ttl>To change the EMP_EVAL.eval_department procedure to use a cursor variable:</ttl> <xreftext>“To change the EMP_EVAL.eval_department procedure to use a cursor variable:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_subprograms042.htm" number="7.10" targetptr="TDDDG49000"> <ttl>Using Associative Arrays</ttl> <xreftext>“Using Associative Arrays”</xreftext> <div element="sect2" href="tdddg_subprograms043.htm" number="7.10.1" targetptr="TDDDG99952"> <ttl>About Collections</ttl> <xreftext>“About Collections”</xreftext> </div> <div element="sect2" href="tdddg_subprograms044.htm" number="7.10.2" targetptr="TDDDG99951"> <ttl>About Associative Arrays</ttl> <xreftext>“About Associative Arrays”</xreftext> </div> <div element="sect2" href="tdddg_subprograms045.htm" number="7.10.3" targetptr="TDDDG99950"> <ttl>Declaring Associative Arrays</ttl> <xreftext>“Declaring Associative Arrays”</xreftext> <obj element="bridgehead" href="tdddg_subprograms045.htm" number="" targetptr="TDDDG241"> <ttl>To use a cursor to declare an associative array:</ttl> <xreftext>“To use a cursor to declare an associative array:”</xreftext> </obj> <obj element="example" href="tdddg_subprograms045.htm" number="7-9" targetptr="TDDDG242"> <ttl>Declaring Associative Arrays</ttl> <xreftext>“Declaring Associative Arrays”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms046.htm" number="7.10.4" targetptr="TDDDG99949"> <ttl>Populating Associative Arrays</ttl> <xreftext>“Populating Associative Arrays”</xreftext> <obj element="bridgehead" href="tdddg_subprograms046.htm" number="" targetptr="TDDDG243"> <ttl>To use a cursor to populate an associative array indexed by integer:</ttl> <xreftext>“To use a cursor to populate an associative array indexed by integer:”</xreftext> </obj> <obj element="example" href="tdddg_subprograms046.htm" number="7-10" targetptr="TDDDG244"> <ttl>Populating Associative Arrays</ttl> <xreftext>“Populating Associative Arrays”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms047.htm" number="7.10.5" targetptr="TDDDG49500"> <ttl>Traversing Dense Associative Arrays</ttl> <xreftext>“Traversing Dense Associative Arrays”</xreftext> <obj element="example" href="tdddg_subprograms047.htm" number="7-11" targetptr="TDDDG245"> <ttl>Traversing a Dense Associative Array</ttl> <xreftext>“Traversing a Dense Associative Array”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms048.htm" number="7.10.6" targetptr="TDDDG99948"> <ttl>Traversing Sparse Associative Arrays</ttl> <xreftext>“Traversing Sparse Associative Arrays”</xreftext> <obj element="example" href="tdddg_subprograms048.htm" number="7-12" targetptr="TDDDG246"> <ttl>Traversing a Sparse Associative Array</ttl> <xreftext>“Traversing a Sparse Associative Array”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_subprograms049.htm" number="7.11" targetptr="TDDDG46000"> <ttl>Handling Exceptions (Run-Time Errors)</ttl> <xreftext>“Handling Exceptions (Run-Time Errors)”</xreftext> <div element="sect2" href="tdddg_subprograms050.htm" number="7.11.1" targetptr="TDDDG99947"> <ttl>About Exceptions and Exception Handlers</ttl> <xreftext>“About Exceptions and Exception Handlers”</xreftext> </div> <div element="sect2" href="tdddg_subprograms051.htm" number="7.11.2" targetptr="TDDDG99940"> <ttl>Handling Predefined Exceptions</ttl> <xreftext>“Handling Predefined Exceptions”</xreftext> <obj element="example" href="tdddg_subprograms051.htm" number="7-13" targetptr="TDDDG247"> <ttl>Handling Predefined Exception NO_DATA_FOUND</ttl> <xreftext>“Handling Predefined Exception NO_DATA_FOUND”</xreftext> </obj> </div> <div element="sect2" href="tdddg_subprograms052.htm" number="7.11.3" targetptr="TDDDG46200"> <ttl>Declaring and Handling User-Defined Exceptions</ttl> <xreftext>“Declaring and Handling User-Defined Exceptions”</xreftext> <obj element="example" href="tdddg_subprograms052.htm" number="7-14" targetptr="TDDDG248"> <ttl>Handling User-Defined Exceptions</ttl> <xreftext>“Handling User-Defined Exceptions”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="tdddg_triggers.htm" number="8" targetptr="TDDDG50000"> <ttl>Using Triggers</ttl> <xreftext>“Using Triggers”</xreftext> <div element="sect1" href="tdddg_triggers001.htm" number="8.1" targetptr="TDDDG51000"> <ttl>About Triggers</ttl> <xreftext>“About Triggers”</xreftext> </div> <div element="sect1" href="tdddg_triggers002.htm" number="8.2" targetptr="TDDDG52000"> <ttl>Creating Triggers</ttl> <xreftext>“Creating Triggers”</xreftext> <div element="sect2" href="tdddg_triggers003.htm" number="8.2.1" targetptr="TDDDG99937"> <ttl>About OLD and NEW Pseudorecords</ttl> <xreftext>“About OLD and NEW Pseudorecords”</xreftext> </div> <div element="sect2" href="tdddg_triggers004.htm" number="8.2.2" targetptr="TDDDG52100"> <ttl>Tutorial: Creating a Trigger that Logs Table Changes</ttl> <xreftext>“Tutorial: Creating a Trigger that Logs Table Changes”</xreftext> <obj element="bridgehead" href="tdddg_triggers004.htm" number="" targetptr="TDDDG249"> <ttl>To create EVALUATIONS_LOG and EVAL_CHANGE_TRIGGER:</ttl> <xreftext>“To create EVALUATIONS_LOG and EVAL_CHANGE_TRIGGER:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_triggers005.htm" number="8.2.3" targetptr="TDDDG52700"> <ttl>Tutorial: Creating a Trigger that Generates a Primary Key for a Row Before It Is Inserted</ttl> <xreftext>“Tutorial: Creating a Trigger that Generates a Primary Key for a Row Before It Is Inserted”</xreftext> <obj element="bridgehead" href="tdddg_triggers005.htm" number="" targetptr="TDDDG250"> <ttl>To create the NEW_EVALUATION trigger:</ttl> <xreftext>“To create the NEW_EVALUATION trigger:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_triggers006.htm" number="8.2.4" targetptr="TDDDG52800"> <ttl>Creating an INSTEAD OF Trigger</ttl> <xreftext>“Creating an INSTEAD OF Trigger”</xreftext> <obj element="example" href="tdddg_triggers006.htm" number="8-1" targetptr="TDDDG251"> <ttl>Creating an INSTEAD OF Trigger</ttl> <xreftext>“Creating an INSTEAD OF Trigger”</xreftext> </obj> </div> <div element="sect2" href="tdddg_triggers007.htm" number="8.2.5" targetptr="TDDDG52900"> <ttl>Creating Triggers that Log LOGON and LOGOFF Events</ttl> <xreftext>“Creating Triggers that Log LOGON and LOGOFF Events”</xreftext> <obj element="bridgehead" href="tdddg_triggers007.htm" number="" targetptr="TDDDG252"> <ttl>To create HR_USERS_LOG, HR_LOGON_TRIGGER, and HR_LOGOFF_TRIGGER:</ttl> <xreftext>“To create HR_USERS_LOG, HR_LOGON_TRIGGER, and HR_LOGOFF_TRIGGER:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_triggers008.htm" number="8.3" targetptr="TDDDG52200"> <ttl>Changing Triggers</ttl> <xreftext>“Changing Triggers”</xreftext> <obj element="bridgehead" href="tdddg_triggers008.htm" number="" targetptr="TDDDG253"> <ttl>To change a standalone stored subprogram using the Edit tool:</ttl> <xreftext>“To change a standalone stored subprogram using the Edit tool:”</xreftext> </obj> </div> <div element="sect1" href="tdddg_triggers009.htm" number="8.4" targetptr="TDDDG52400"> <ttl>Disabling and Enabling Triggers</ttl> <xreftext>“Disabling and Enabling Triggers”</xreftext> </div> <div element="sect1" href="tdddg_triggers010.htm" number="8.5" targetptr="TDDDG52500"> <ttl>About Trigger Compilation and Dependencies</ttl> <xreftext>“About Trigger Compilation and Dependencies”</xreftext> </div> <div element="sect1" href="tdddg_triggers011.htm" number="8.6" targetptr="TDDDG52600"> <ttl>Dropping Triggers</ttl> <xreftext>“Dropping Triggers”</xreftext> <obj element="bridgehead" href="tdddg_triggers011.htm" number="" targetptr="TDDDG254"> <ttl>To drop a trigger using the Drop tool:</ttl> <xreftext>“To drop a trigger using the Drop tool:”</xreftext> </obj> </div> </div> <div element="chapter" href="tdddg_globalization.htm" number="9" targetptr="TDDDG60000"> <ttl>Working in a Global Environment</ttl> <xreftext>“Working in a Global Environment”</xreftext> <div element="sect1" href="tdddg_globalization001.htm" number="9.1" targetptr="TDDDG61000"> <ttl>About Globalization Support Features</ttl> <xreftext>“About Globalization Support Features”</xreftext> <div element="sect2" href="tdddg_globalization002.htm" number="9.1.1" targetptr="TDDDG99945"> <ttl>About Language Support</ttl> <xreftext>“About Language Support”</xreftext> </div> <div element="sect2" href="tdddg_globalization003.htm" number="9.1.2" targetptr="TDDDG99944"> <ttl>About Territory Support</ttl> <xreftext>“About Territory Support”</xreftext> </div> <div element="sect2" href="tdddg_globalization004.htm" number="9.1.3" targetptr="TDDDG255"> <ttl>About Date and Time Formats</ttl> <xreftext>“About Date and Time Formats”</xreftext> </div> <div element="sect2" href="tdddg_globalization005.htm" number="9.1.4" targetptr="TDDDG62510"> <ttl>About Calendar Formats</ttl> <xreftext>“About Calendar Formats”</xreftext> </div> <div element="sect2" href="tdddg_globalization006.htm" number="9.1.5" targetptr="TDDDG62600"> <ttl>About Numeric and Monetary Formats</ttl> <xreftext>“About Numeric and Monetary Formats”</xreftext> </div> <div element="sect2" href="tdddg_globalization007.htm" number="9.1.6" targetptr="TDDDG62800"> <ttl>About Linguistic Sorting and String Searching</ttl> <xreftext>“About Linguistic Sorting and String Searching”</xreftext> </div> <div element="sect2" href="tdddg_globalization008.htm" number="9.1.7" targetptr="TDDDG62900"> <ttl>About Length Semantics</ttl> <xreftext>“About Length Semantics”</xreftext> </div> <div element="sect2" href="tdddg_globalization009.htm" number="9.1.8" targetptr="TDDDG63100"> <ttl>About Unicode and SQL National Character Data Types</ttl> <xreftext>“About Unicode and SQL National Character Data Types”</xreftext> </div> </div> <div element="sect1" href="tdddg_globalization010.htm" number="9.2" targetptr="TDDDG99978"> <ttl>About Initial NLS Parameter Values</ttl> <xreftext>“About Initial NLS Parameter Values”</xreftext> <obj element="table" href="tdddg_globalization010.htm" number="9-1" targetptr="TDDDG256"> <ttl>Initial Values of NLS Parameters in SQL Developer</ttl> <xreftext>“Initial Values of NLS Parameters in SQL Developer”</xreftext> </obj> </div> <div element="sect1" href="tdddg_globalization011.htm" number="9.3" targetptr="TDDDG61200"> <ttl>Viewing NLS Parameter Values</ttl> <xreftext>“Viewing NLS Parameter Values”</xreftext> <obj element="bridgehead" href="tdddg_globalization011.htm" number="" targetptr="TDDDG257"> <ttl>To view the National Language Support Parameters report:</ttl> <xreftext>“To view the National Language Support Parameters report:”</xreftext> </obj> </div> <div element="sect1" href="tdddg_globalization012.htm" number="9.4" targetptr="TDDDG99946"> <ttl>Changing NLS Parameter Values</ttl> <xreftext>“Changing NLS Parameter Values”</xreftext> <div element="sect2" href="tdddg_globalization013.htm" number="9.4.1" targetptr="TDDDG65100"> <ttl>Changing NLS Parameter Values for All SQL Developer Connections</ttl> <xreftext>“Changing NLS Parameter Values for All SQL Developer Connections”</xreftext> <obj element="bridgehead" href="tdddg_globalization013.htm" number="" targetptr="TDDDG258"> <ttl>To change National Language Support Parameter values:</ttl> <xreftext>“To change National Language Support Parameter values:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization014.htm" number="9.4.2" targetptr="TDDDG64000"> <ttl>Changing NLS Parameter Values for the Current SQL Function Invocation</ttl> <xreftext>“Changing NLS Parameter Values for the Current SQL Function Invocation”</xreftext> </div> </div> <div element="sect1" href="tdddg_globalization015.htm" number="9.5" targetptr="TDDDG62000"> <ttl>About Individual NLS Parameters</ttl> <xreftext>“About Individual NLS Parameters”</xreftext> <div element="sect2" href="tdddg_globalization016.htm" number="9.5.1" targetptr="TDDDG62100"> <ttl>About Locale and the NLS_LANG Parameter</ttl> <xreftext>“About Locale and the NLS_LANG Parameter”</xreftext> </div> <div element="sect2" href="tdddg_globalization017.htm" number="9.5.2" targetptr="TDDDG62310"> <ttl>About the NLS_LANGUAGE Parameter</ttl> <xreftext>“About the NLS_LANGUAGE Parameter”</xreftext> <obj element="example" href="tdddg_globalization017.htm" number="9-1" targetptr="TDDDG259"> <ttl>NLS_LANGUAGE Affects Server Message and Month Abbreviations</ttl> <xreftext>“NLS_LANGUAGE Affects Server Message and Month Abbreviations”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization018.htm" number="9.5.3" targetptr="TDDDG62320"> <ttl>About the NLS_TERRITORY Parameter</ttl> <xreftext>“About the NLS_TERRITORY Parameter”</xreftext> <obj element="example" href="tdddg_globalization018.htm" number="9-2" targetptr="TDDDG260"> <ttl>NLS_TERRITORY Affects Currency Symbol</ttl> <xreftext>“NLS_TERRITORY Affects Currency Symbol”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization019.htm" number="9.5.4" targetptr="TDDDG62410"> <ttl>About the NLS_DATE_FORMAT Parameter</ttl> <xreftext>“About the NLS_DATE_FORMAT Parameter”</xreftext> <obj element="example" href="tdddg_globalization019.htm" number="9-3" targetptr="TDDDG261"> <ttl>NLS_TERRITORY Affects Date Formats</ttl> <xreftext>“NLS_TERRITORY Affects Date Formats”</xreftext> </obj> <obj element="example" href="tdddg_globalization019.htm" number="9-4" targetptr="TDDDG262"> <ttl>NLS_DATE_FORMAT Overrides NLS_TERRITORY</ttl> <xreftext>“NLS_DATE_FORMAT Overrides NLS_TERRITORY”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization020.htm" number="9.5.5" targetptr="TDDDG99982"> <ttl>About the NLS_DATE_LANGUAGE Parameter</ttl> <xreftext>“About the NLS_DATE_LANGUAGE Parameter”</xreftext> <obj element="example" href="tdddg_globalization020.htm" number="9-5" targetptr="TDDDG263"> <ttl>NLS_DATE_LANGUAGE Affects Displayed SYSDATE</ttl> <xreftext>“NLS_DATE_LANGUAGE Affects Displayed SYSDATE”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization021.htm" number="9.5.6" targetptr="TDDDG99981"> <ttl>About the NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT Parameters</ttl> <xreftext>“About the NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT Parameters”</xreftext> </div> <div element="sect2" href="tdddg_globalization022.htm" number="9.5.7" targetptr="TDDDG62520"> <ttl>About the NLS_CALENDAR Parameter</ttl> <xreftext>“About the NLS_CALENDAR Parameter”</xreftext> <obj element="example" href="tdddg_globalization022.htm" number="9-6" targetptr="TDDDG264"> <ttl>NLS_CALENDAR Affects Displayed SYSDATE</ttl> <xreftext>“NLS_CALENDAR Affects Displayed SYSDATE”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization023.htm" number="9.5.8" targetptr="TDDDG62620"> <ttl>About the NLS_NUMERIC_CHARACTERS Parameter</ttl> <xreftext>“About the NLS_NUMERIC_CHARACTERS Parameter”</xreftext> <obj element="example" href="tdddg_globalization023.htm" number="9-7" targetptr="TDDDG265"> <ttl>NLS_NUMERIC_CHARACTERS Affects Decimal Character and Group Separator</ttl> <xreftext>“NLS_NUMERIC_CHARACTERS Affects Decimal Character and Group Separator”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization024.htm" number="9.5.9" targetptr="TDDDG62720"> <ttl>About the NLS_CURRENCY Parameter</ttl> <xreftext>“About the NLS_CURRENCY Parameter”</xreftext> <obj element="example" href="tdddg_globalization024.htm" number="9-8" targetptr="TDDDG266"> <ttl>NLS_CURRENCY Overrides NLS_TERRITORY</ttl> <xreftext>“NLS_CURRENCY Overrides NLS_TERRITORY”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization025.htm" number="9.5.10" targetptr="TDDDG62730"> <ttl>About the NLS_ISO_CURRENCY Parameter</ttl> <xreftext>“About the NLS_ISO_CURRENCY Parameter”</xreftext> <obj element="example" href="tdddg_globalization025.htm" number="9-9" targetptr="TDDDG267"> <ttl>NLS_ISO_CURRENCY</ttl> <xreftext>“NLS_ISO_CURRENCY”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization026.htm" number="9.5.11" targetptr="TDDDG62740"> <ttl>About the NLS_DUAL_CURRENCY Parameter</ttl> <xreftext>“About the NLS_DUAL_CURRENCY Parameter”</xreftext> </div> <div element="sect2" href="tdddg_globalization027.htm" number="9.5.12" targetptr="TDDDG62810"> <ttl>About the NLS_SORT Parameter</ttl> <xreftext>“About the NLS_SORT Parameter”</xreftext> <obj element="example" href="tdddg_globalization027.htm" number="9-10" targetptr="TDDDG268"> <ttl>NLS_SORT Affects Linguistic Sort Order</ttl> <xreftext>“NLS_SORT Affects Linguistic Sort Order”</xreftext> </obj> <obj element="bridgehead" href="tdddg_globalization027.htm" number="" targetptr="TDDDG269"> <ttl>Case-Insensitive and Accent-Insensitive Sorts</ttl> <xreftext>“Case-Insensitive and Accent-Insensitive Sorts”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization028.htm" number="9.5.13" targetptr="TDDDG62820"> <ttl>About the NLS_COMP Parameter</ttl> <xreftext>“About the NLS_COMP Parameter”</xreftext> <obj element="example" href="tdddg_globalization028.htm" number="9-11" targetptr="TDDDG270"> <ttl>NLS_COMP Affects SQL Character Comparison</ttl> <xreftext>“NLS_COMP Affects SQL Character Comparison”</xreftext> </obj> </div> <div element="sect2" href="tdddg_globalization029.htm" number="9.5.14" targetptr="TDDDG62910"> <ttl>About the NLS_LENGTH_SEMANTICS Parameter</ttl> <xreftext>“About the NLS_LENGTH_SEMANTICS Parameter”</xreftext> <obj element="example" href="tdddg_globalization029.htm" number="9-12" targetptr="TDDDG271"> <ttl>NLS_LENGTH_SEMANTICS Affects Storage of VARCHAR2 Column</ttl> <xreftext>“NLS_LENGTH_SEMANTICS Affects Storage of VARCHAR2 Column”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_globalization030.htm" number="9.6" targetptr="TDDDG63000"> <ttl>Using Unicode in Globalized Applications</ttl> <xreftext>“Using Unicode in Globalized Applications”</xreftext> <div element="sect2" href="tdddg_globalization031.htm" number="9.6.1" targetptr="TDDDG63300"> <ttl>Representing Unicode String Literals in SQL and PL/SQL</ttl> <xreftext>“Representing Unicode String Literals in SQL and PL/SQL”</xreftext> </div> <div element="sect2" href="tdddg_globalization032.htm" number="9.6.2" targetptr="TDDDG63400"> <ttl>Avoiding Data Loss During Character-Set Conversion</ttl> <xreftext>“Avoiding Data Loss During Character-Set Conversion”</xreftext> </div> </div> </div> <div element="chapter" href="tdddg_deploying.htm" number="10" targetptr="TDDDG70000"> <ttl>Deploying an Oracle Database Application</ttl> <xreftext>“Deploying an Oracle Database Application”</xreftext> <div element="sect1" href="tdddg_deploying001.htm" number="10.1" targetptr="TDDDG72000"> <ttl>About Deployment Environments</ttl> <xreftext>“About Deployment Environments”</xreftext> </div> <div element="sect1" href="tdddg_deploying002.htm" number="10.2" targetptr="TDDDG99980"> <ttl>About Installation Script Files</ttl> <xreftext>“About Installation Script Files”</xreftext> <div element="sect2" href="tdddg_deploying003.htm" number="10.2.1" targetptr="TDDDG99943"> <ttl>About DDL Statements and Schema Object Dependencies</ttl> <xreftext>“About DDL Statements and Schema Object Dependencies”</xreftext> </div> <div element="sect2" href="tdddg_deploying004.htm" number="10.2.2" targetptr="TDDDG99942"> <ttl>About INSERT Statements and Constraints</ttl> <xreftext>“About INSERT Statements and Constraints”</xreftext> </div> </div> <div element="sect1" href="tdddg_deploying005.htm" number="10.3" targetptr="TDDDG74000"> <ttl>Creating Installation Script Files</ttl> <xreftext>“Creating Installation Script Files”</xreftext> <div element="sect2" href="tdddg_deploying006.htm" number="10.3.1" targetptr="TDDDG99974"> <ttl>Creating an Installation Script File with SQL Developer</ttl> <xreftext>“Creating an Installation Script File with SQL Developer”</xreftext> <obj element="bridgehead" href="tdddg_deploying006.htm" number="" targetptr="TDDDG272"> <ttl>To create an installation script file with the Database Export tool:</ttl> <xreftext>“To create an installation script file with the Database Export tool:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_deploying007.htm" number="10.3.2" targetptr="TDDDG99938"> <ttl>Editing Installation Script Files that Create Sequences</ttl> <xreftext>“Editing Installation Script Files that Create Sequences”</xreftext> </div> <div element="sect2" href="tdddg_deploying008.htm" number="10.3.3" targetptr="TDDDG74100"> <ttl>Editing Installation Script Files that Create Triggers</ttl> <xreftext>“Editing Installation Script Files that Create Triggers”</xreftext> </div> <div element="sect2" href="tdddg_deploying009.htm" number="10.3.4" targetptr="TDDDG74200"> <ttl>Tutorial: Creating an Installation Script File for the Sequence and Tables</ttl> <xreftext>“Tutorial: Creating an Installation Script File for the Sequence and Tables”</xreftext> <obj element="bridgehead" href="tdddg_deploying009.htm" number="" targetptr="TDDDG273"> <ttl>To create an installation script file for the tables and sequence:</ttl> <xreftext>“To create an installation script file for the tables and sequence:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_deploying010.htm" number="10.3.5" targetptr="TDDDG74300"> <ttl>Tutorial: Creating an Installation Script File for the Package</ttl> <xreftext>“Tutorial: Creating an Installation Script File for the Package”</xreftext> <obj element="bridgehead" href="tdddg_deploying010.htm" number="" targetptr="TDDDG274"> <ttl>To create an installation script file for the package:</ttl> <xreftext>“To create an installation script file for the package:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_deploying011.htm" number="10.3.6" targetptr="TDDDG74400"> <ttl>Tutorial: Creating an Installation Script File for the Synonym and View</ttl> <xreftext>“Tutorial: Creating an Installation Script File for the Synonym and View”</xreftext> <obj element="bridgehead" href="tdddg_deploying011.htm" number="" targetptr="TDDDG275"> <ttl>To create an installation script file for the synonym and view:</ttl> <xreftext>“To create an installation script file for the synonym and view:”</xreftext> </obj> </div> <div element="sect2" href="tdddg_deploying012.htm" number="10.3.7" targetptr="TDDDG75000"> <ttl>Tutorial: Creating an Installation Script File for the Data</ttl> <xreftext>“Tutorial: Creating an Installation Script File for the Data”</xreftext> <obj element="bridgehead" href="tdddg_deploying012.htm" number="" targetptr="TDDDG276"> <ttl>To create an installation script file for the data:</ttl> <xreftext>“To create an installation script file for the data:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdddg_deploying013.htm" number="10.4" targetptr="TDDDG76000"> <ttl>Installing the Sample Application</ttl> <xreftext>“Installing the Sample Application”</xreftext> <obj element="bridgehead" href="tdddg_deploying013.htm" number="" targetptr="TDDDG277"> <ttl>To install the sample application using SQL Developer:</ttl> <xreftext>“To install the sample application using SQL Developer:”</xreftext> </obj> </div> <div element="sect1" href="tdddg_deploying014.htm" number="10.5" targetptr="TDDDG77000"> <ttl>Checking the Validity of an Installation</ttl> <xreftext>“Checking the Validity of an Installation”</xreftext> </div> <div element="sect1" href="tdddg_deploying015.htm" number="10.6" targetptr="TDDDG78000"> <ttl>Archiving the Installation Script Files</ttl> <xreftext>“Archiving the Installation Script Files”</xreftext> </div> </div> </div>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de