Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc

Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc_helper\toc3.html

<html xmlns:htmldb="http://htmldb.oracle.com"><head>		<META http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Page title</title><script src="../javascript/htmldb_html_elements.js" type="text/javascript"></script><script type="text/javascript">
					function HT(pThis,pId){
						htmldb_ToggleWithImage(pThis,pId);
						return;
					}
					
					var gCurrent = false;
					
					function MC(pThis){
					if(gCurrent){gCurrent.id = ''}
					pThis.id='current';
					gCurrent = pThis;
					}
					
					
				</script><style>
				/* tag defaults */
*{font-size:9pt;}
body {background-color:#EEEEEE; margin:0; padding:0; font-family: Arial, Helvetica, Geneva, sans-serif;}
td, body, p, div, span{font-family: Arial, Helvetica, Geneva, sans-serif;font-size:9pt;color:#000000;}
a{text-decoration:none;padding:1px;}
a:link,a:visited{color:#000000;border:1px solid #EEEEEE;}
a:active,a:hover{color:#000000;border:1px solid #444444;background-color:#CCCCCC;}
li{display:block;padding:2px;white-space:nowrap;}
#current{color:#000000;border:1px solid #444444;background-color:#CCCCCC;}
/**/
ul{margin-left:1em;padding-left:0;list-style:none;}
.e{cursor:hand;cursor:pointer;}
.ch{display:none;}
.pseudoButtonInactive{cursor:hand;cursor:pointer;}
.pseudoButtonActive{cursor:hand;cursor:pointer;}
</style></head><body><div>
			<ul class="dhtmlTree"><li><img src="plus.jpg" class="e" onclick="HT(this,'preface.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/preface.htm">Preface</a></li><ul style="display:none;" id="preface.htm" htmldb:listlevel="1"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/preface.htm#BABBCADJ">Documentation Topics</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/preface.htm#BABBIIED">Audience</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/preface.htm#CIABBJEH">Documentation Accessibility</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/preface.htm#BABDCEIC">Related Documentation</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/preface.htm#BABIACIH">Conventions</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_intro.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_intro.htm"> Overview of Development </a></li><ul style="display:none;" id="xedev_intro.htm" htmldb:listlevel="1"><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_ovrw_develop.htm-CHDBJEHE')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_develop.htm#CHDBJEHE">Overview of Developing Applications With Oracle Database XE</a></li><ul style="display:none;" id="xedev_ovrw_develop.htm-CHDBJEHE" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_dev_db.htm#CHDDEGDA">Oracle Database Express Edition</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_dev_sql.htm#CHDJAAFJ">SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_dev_plsql.htm#i1006218">PL/SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_dev_dbobjs.htm#CHDFFFCE">Database Objects</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_dev_basic.htm#CHDFDDJI">Basic Application Development Concepts</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_ovrw_dev_tools.htm-CHDIBDGJ')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_dev_tools.htm#CHDIBDGJ">Development Tools</a></li><ul style="display:none;" id="xedev_ovrw_dev_tools.htm-CHDIBDGJ" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_dev_tools.htm#CHDEGABG">Logging in to the Database Home Page</a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_hr_schema.htm#CHDIEDCF">Sample HR Account</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_ovrw_otherdev.htm-CHDFCCEB')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev.htm#CHDFCCEB">Other Development Environments</a></li><ul style="display:none;" id="xedev_ovrw_otherdev.htm-CHDFCCEB" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev_oci.htm#CHDDCDFC">Oracle Call Interface and Oracle C++ Call Interface</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev_odbc.htm#CHDDEFIB">Open Database Connectivity</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev_oledb.htm#CHDCGBJF">Oracle Provider for OLE DB</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev_odpnet.htm#CHDGJDFC">Oracle Data Provider for .NET</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev_netext.htm#CHDFGDEA">Oracle Database Extensions for .NET</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev_vs.htm#CHDJFFGC">Oracle Developer Tools for Visual Studio .NET</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev_htmldb.htm#CHDFFDCG">Oracle Application Express</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev_jdbc.htm#CHDGGJIG">Oracle Java Database Connectivity (JDBC)</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_ovrw_otherdev_php.htm#CHDGAFAJ">PHP</a></li></ul>
				</ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_design.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design.htm"> Managing Database Objects </a></li><ul style="display:none;" id="xedev_design.htm" htmldb:listlevel="1"><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_manage_ovrw.htm-CFHHBEGH')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_manage_ovrw.htm#CFHHBEGH">Overview of Managing Objects</a></li><ul style="display:none;" id="xedev_manage_ovrw.htm-CFHHBEGH" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design001.htm#BGBFHIDJ">Database Objects for Your Application</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design002.htm#CACJGABG">Managing Database Objects With Object Browser</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design003.htm#CACDBEHI">Viewing Data in Tables With Object Browser</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design004.htm#CACHJJGB">Viewing Information With Object Reports</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_types.htm-CACDJDHH')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types.htm#CACDJDHH">Using Datatypes</a></li><ul style="display:none;" id="xedev_types.htm-CACDJDHH" htmldb:listlevel="2"><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_types_char.htm-BABEFDEF')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types_char.htm#BABEFDEF">Storing Character Data</a></li><ul style="display:none;" id="xedev_types_char.htm-BABEFDEF" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types_char.htm#BABCDHHH">What Are the Character Datatypes?</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types_char.htm#BABICBHE">Choosing Between the Character Datatypes</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_types_numeric.htm-BABBAHFE')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types_numeric.htm#BABBAHFE">Storing Numeric Data</a></li><ul style="display:none;" id="xedev_types_numeric.htm-BABBAHFE" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types_numeric.htm#BABEDJBI">What Are the Numeric Datatypes?</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types_numeric.htm#CHDCIDEJ">Using the NUMBER Datatype</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types_numeric.htm#BABGHIHF">Using Floating-Point Number Formats</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_types_datetime.htm-BABJJCAI')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types_datetime.htm#BABJJCAI">Storing Date and Time Data</a></li><ul style="display:none;" id="xedev_types_datetime.htm-BABJJCAI" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_types_datetime.htm#BABIDDJI">Using DATE and TIMESTAMP Datatypes</a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design005.htm#CACJBEJC">Storing Large Objects</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_manage_table.htm-CFHEIBFG')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_manage_table.htm#CFHEIBFG">Managing Tables</a></li><ul style="display:none;" id="xedev_manage_table.htm-CFHEIBFG" htmldb:listlevel="2"><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_design006.htm-CACJJFEE')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design006.htm#CACJJFEE">Ensuring Data Integrity in Tables With Constraints</a></li><ul style="display:none;" id="xedev_design006.htm-CACJJFEE" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design006.htm#CACGEDBF">Column Default Value</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design006.htm#CACICDHE">NOT NULL Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design006.htm#CACCFFBI">Check Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design006.htm#CACFICBB">Unique Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design006.htm#CACJABEF">Primary Key Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design006.htm#CACFCIHG">Foreign Key Constraint</a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design007.htm#BEABGHHE">Creating a Table</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design008.htm#BGBCIIJE">Adding a Column To a Table</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design009.htm#CACDIIGJ">Modifying a Column In a Table</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design010.htm#CACCAGGG">Dropping a Column From a Table</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design011.htm#CACDECHI">Adding a Check Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design012.htm#CBBEEEAJ">Adding a Unique Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design013.htm#CACBJHGD">Adding a Primary Key Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design014.htm#CACDFDFD">Adding a Foreign Key Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design015.htm#CACGFDEH">Viewing Existing Constraints</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design016.htm#CACGAHID">Disabling and Enabling a Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design017.htm#CACGJHAI">Dropping a Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design018.htm#CACDECIF">Adding Data to a Table</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design019.htm#CACGGIFB">Modifying Data in a Table</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design020.htm#CACJJFIC">Removing a Row in a Table</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design021.htm#CACBEHIF">Dropping a Table</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_manage_index.htm-BGBDBDFB')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_manage_index.htm#BGBDBDFB">Managing Indexes</a></li><ul style="display:none;" id="xedev_manage_index.htm-BGBDBDFB" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design022.htm#CACDECBH">Index Types</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design023.htm#CACDFDBE">Indexes for Use with Constraints</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_design024.htm-i1007888')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design024.htm#i1007888">Guidelines for Creating Indexes</a></li><ul style="display:none;" id="xedev_design024.htm-i1007888" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design024.htm#i1006255">Index the Correct Tables and Columns</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design024.htm#CACBJBEG">Limit the Number of Indexes for Each Table</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design024.htm#CACDGFAJ">Drop Indexes That Are No Longer Required </a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design025.htm#CACJBHJF">Creating an Index</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design026.htm#CACJHJFD">Displaying an Index for a Table</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design027.htm#CACHIICC">Dropping an Index</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_manage_view.htm-BGBICDFE')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_manage_view.htm#BGBICDFE">Managing Views</a></li><ul style="display:none;" id="xedev_manage_view.htm-BGBICDFE" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design028.htm#CACBBBBG">Creating a View</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design029.htm#CACEFBEA">Displaying a View</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design030.htm#CACGAFCA">Dropping a View</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_manage_sequence.htm-BGBBGEBF')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_manage_sequence.htm#BGBBGEBF">Managing Sequences</a></li><ul style="display:none;" id="xedev_manage_sequence.htm-BGBBGEBF" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design031.htm#CACGEGFI">Creating a Sequence</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design032.htm#CACDFABC">Displaying a Sequence</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design033.htm#CACCCIAC">Dropping a Sequence</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_manage_synonym.htm-CACGDDFC')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_manage_synonym.htm#CACGDDFC">Managing Synonyms</a></li><ul style="display:none;" id="xedev_manage_synonym.htm-CACGDDFC" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design034.htm#CACIJDJE">Creating a Synonym</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design035.htm#CACEFFEA">Displaying a Synonym</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_design036.htm#CACDCHHH">Dropping a Synonym</a></li></ul>
				</ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sql.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql.htm"> Using SQL </a></li><ul style="display:none;" id="xedev_sql.htm" htmldb:listlevel="1"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql_ovrw.htm#i1411">Overview of SQL</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sql_execute.htm-BJEFEGCD')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql_execute.htm#BJEFEGCD">Running SQL Statements</a></li><ul style="display:none;" id="xedev_sql_execute.htm-BJEFEGCD" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql001.htm#BJEBEIDD">Running SQL Statements on the SQL Commands Page</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql002.htm#BJEIEIFJ">Running SQL Statements in the Script Editor Page</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sql_query.htm-BJEHCDDI')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql_query.htm#BJEHCDDI">Retrieving Data With Queries</a></li><ul style="display:none;" id="xedev_sql_query.htm-BJEHCDDI" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql003.htm#BJEHDJCB">Displaying Data Using the SELECT Statement</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql004.htm#BJEGGBIG">Using a Column Alias to Change Headings When Selecting Data</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sql005.htm-BJEJJBGD')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql005.htm#BJEJJBGD">Restricting Data Using the WHERE Clause</a></li><ul style="display:none;" id="xedev_sql005.htm-BJEJJBGD" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql005.htm#BABFEDBG">Using Character Literals in SQL Statements</a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql006.htm#BJECDGAJ">Using Regular Expressions When Selecting Data</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql007.htm#BJEGFAFE">Sorting Data Using the ORDER BY Clause</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql008.htm#BJEHEBBC">Displaying Data From Multiple Tables</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql009.htm#BJECCJJD">Using Bind Variables With the SQL Commands Page</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sql_functions.htm-BJEJBCCJ')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql_functions.htm#BJEJBCCJ">Using Pseudocolumns, Sequences, and SQL Functions</a></li><ul style="display:none;" id="xedev_sql_functions.htm-BJEJBCCJ" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql010.htm#BJECIHBJ">Using ROWNUM, SYSDATE, and USER Pseudocolumns With SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql011.htm#BJECBEIJ">Using Arithmetic Operators</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql012.htm#BJEJGGFI">Using Numeric Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql013.htm#BJEFGHGE">Using Character Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql014.htm#BJEDCCGE">Using Date Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql015.htm#BJEEHIHD">Using Conversion Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql016.htm#BJEDAHCA">Using Aggregate Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql017.htm#BJECAJAJ">Using NULL Value Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql018.htm#BJEJGEGH">Using Conditional Functions</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sql_manipulate.htm-i18503')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql_manipulate.htm#i18503">Manipulating Data With SQL Statements</a></li><ul style="display:none;" id="xedev_sql_manipulate.htm-i18503" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql019.htm#BJECDBCJ">Adding Data With the INSERT Statement</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql020.htm#BJEJJICI">Updating Data With the UPDATE Statement</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql021.htm#BJEGIAEF">Deleting Data With the DELETE Statement</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sql_transaction.htm-i18511')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql_transaction.htm#i18511">Using Transaction Control Statements</a></li><ul style="display:none;" id="xedev_sql_transaction.htm-i18511" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql022.htm#BJEIDFAG">Committing Transaction Changes</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql023.htm#BJEBGGJI">Rolling Back a Transaction</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sql_definition.htm-BJEJHFIH')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql_definition.htm#BJEJHFIH">Using Data Definition Language Statements to Manage Database Objects</a></li><ul style="display:none;" id="xedev_sql_definition.htm-BJEJHFIH" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql024.htm#BJEJEAFB">Creating a Table With SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql025.htm#BJEFECJC">Adding, Altering, and Dropping a Table Column With SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql026.htm#BJEDIADD">Creating and Altering a Constraint With SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql027.htm#BJEIFAIA">Renaming a Table With SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql028.htm#BJEJAEJJ">Dropping a Table With SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql029.htm#BJEBBDAF">Creating, Altering, and Dropping an Index With SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql030.htm#BJEFAICB">Creating and Dropping a View With SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql031.htm#BJEEAJHE">Creating and Dropping a Sequence With SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sql032.htm#BJEEBGJH">Creating and Dropping a Synonym With SQL</a></li></ul>
				</ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_plsql.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql.htm"> Using PL/SQL </a></li><ul style="display:none;" id="xedev_plsql.htm" htmldb:listlevel="1"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql_ovrw.htm#CHDIIAII">Overview of PL/SQL</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_plsql_execute.htm-CHDJIBGF')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql_execute.htm#CHDJIBGF">Entering and Running PL/SQL Code</a></li><ul style="display:none;" id="xedev_plsql_execute.htm-CHDJIBGF" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql001.htm#CHDGFAAC">Running PL/SQL Code in the SQL Commands Page</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_plsql_utilizing.htm-i8854')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql_utilizing.htm#i8854">Using the Main Features of PL/SQL</a></li><ul style="display:none;" id="xedev_plsql_utilizing.htm-i8854" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql002.htm#i8859">Using the PL/SQL Block Structure</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql003.htm#CBJGHHBG">Inputting and Outputting Data with PL/SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql004.htm#CHDGFFCC">Using Comments</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql005.htm#CJAFEIFF">Declaring Variables and Constants</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql006.htm#CHDFHDGC">Using Identifiers in PL/SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql007.htm#CHDDIHAG">Assigning Values to a Variable With the Assignment Operator</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql008.htm#CHDIFDIJ">Using Literals</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql009.htm#CHDFDIFB">Declaring and Assigning Variables With the DEFAULT Keyword or NOT NULL Constraint</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql010.htm#CHDEIBFJ">Assigning Values to a Variable With the PL/SQL SELECT INTO Statement</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_plsql011.htm-CHDEEHGE')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql011.htm#CHDEEHGE">Using %TYPE and %ROWTYPE Attributes to Declare Identical Datatypes</a></li><ul style="display:none;" id="xedev_plsql011.htm-CHDEEHGE" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql011.htm#CHDICDED">Using the %TYPE Attribute to Declare Variables</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql011.htm#CHDGBDHC">Using the %ROWTYPE Attribute to Declare Variables</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_plsql012.htm-i7369')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql012.htm#i7369">Using PL/SQL Control Structures</a></li><ul style="display:none;" id="xedev_plsql012.htm-i7369" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql012.htm#i1736">Conditional Control With IF-THEN</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql012.htm#CHDCDJCE">Conditional Control With the CASE Statement</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql012.htm#i8422">Iterative Control With LOOPs</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql012.htm#CHDGEDAA">Sequential Control With GOTO</a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql013.htm#CHDEEEAH">Using Local PL/SQL Procedures and Functions in PL/SQL Blocks</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_plsql014.htm-BABHIDEG')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql014.htm#BABHIDEG">Using Cursors To Retrieve Data</a></li><ul style="display:none;" id="xedev_plsql014.htm-BABHIDEG" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql014.htm#CHDBEIDG">Cursor Attributes</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_plsql015.htm-CHDFDHJH')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql015.htm#CHDFDHJH">Working With PL/SQL Data Structures</a></li><ul style="display:none;" id="xedev_plsql015.htm-CHDFDHJH" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql015.htm#CHDEAGBB">Using Record Types</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql015.htm#CHDFJCED">Using Collections</a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql016.htm#CHDJFJBG">Using Bind Variables With PL/SQL</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql017.htm#CHDCEGHI">Using Dynamic SQL in PL/SQL</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_plsql_errors.htm-CHDHJHEA')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql_errors.htm#CHDHJHEA">Handling PL/SQL Errors</a></li><ul style="display:none;" id="xedev_plsql_errors.htm-CHDHJHEA" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_errors_predefined.htm#i9355">Summary of Predefined PL/SQL Exceptions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql018.htm#CHDCIHBE">Using the Exception Handler</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql019.htm#CHDEGCGA">Declaring PL/SQL Exceptions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql020.htm#CHDGFBAH">Scope Rules for PL/SQL Exceptions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_plsql021.htm#CHDIAEHJ">Continuing After an Exception Is Raised</a></li></ul>
				</ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_programs.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs.htm"> Using Procedures, Functions, and Packages </a></li><ul style="display:none;" id="xedev_programs.htm" htmldb:listlevel="1"><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_programs_ovrw.htm-BABEEEJF')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs_ovrw.htm#BABEEEJF">Overview of Procedures, Functions, and Packages</a></li><ul style="display:none;" id="xedev_programs_ovrw.htm-BABEEEJF" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs001.htm#BABHIAJA">Stored Procedures and Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs002.htm#BABFDDAI">Packages</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_programs_subprograms.htm-BABHGIHI')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs_subprograms.htm#BABHGIHI">Managing Stored Procedures and Functions</a></li><ul style="display:none;" id="xedev_programs_subprograms.htm-BABHGIHI" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs003.htm#BABCGHAJ">Creating a Procedure or Function With the SQL Commands Page</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs004.htm#BABDAJDG">Creating a Procedure or Function With the Object Browser Page</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs005.htm#BABCJCIF">Viewing Procedures or Functions With the Object Browser Page</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs006.htm#CJACCHHA">Creating Stored Procedures With SQL CREATE PROCEDURE</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs007.htm#BABCDCHI">Creating a Stored Procedure That Uses Parameters</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs008.htm#BABIJGIJ">Creating a Stored Procedure With the AUTHID Clause</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs009.htm#BABBJDGF">Creating Stored Functions With the SQL CREATE FUNCTION Statement</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs010.htm#BABDADEE">Calling Stored Procedures or Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs011.htm#BABEFGAH">Editing Procedures or Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs012.htm#BABBAAEJ">Dropping a Procedure or Function</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_programs_packages.htm-CFHEDEEI')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs_packages.htm#CFHEDEEI">Managing Packages</a></li><ul style="display:none;" id="xedev_programs_packages.htm-CFHEDEEI" htmldb:listlevel="2"><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_programs013.htm-CHDCCACC')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs013.htm#CHDCCACC">Writing Packages With PL/SQL Code</a></li><ul style="display:none;" id="xedev_programs013.htm-CHDCCACC" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs013.htm#i7562">Guidelines for Writing Packages</a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs014.htm#BABEGGDA">Creating Packages in the SQL Commands Page</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs015.htm#BABDAFEC">Creating Packages With the Object Browser Page</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs016.htm#BEAJJCHA">Viewing Packages With the Object Browser Page</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs017.htm#BABCDJGG">Creating Packages With the SQL CREATE PACKAGE Statement</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs018.htm#BABEIBAD">Editing Packages</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs019.htm#BABEFCHC">Dropping Packages</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs020.htm#BABBIICE">Calling Procedures and Functions in Packages</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs021.htm#BABFEEID">Accessing Variables in Packages</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_programs_oracle.htm-i2432')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs_oracle.htm#i2432">Oracle Provided Packages</a></li><ul style="display:none;" id="xedev_programs_oracle.htm-i2432" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs022.htm#BABCCDFB">List of Oracle Database XE Packages</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_programs023.htm-BABGJAFB')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs023.htm#BABGJAFB">Overview of Some Useful Packages</a></li><ul style="display:none;" id="xedev_programs023.htm-BABGJAFB" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs023.htm#BABGDHEF">DBMS_OUTPUT Package</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs023.htm#BABJHGEG">DBMS_RANDOM Package</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs023.htm#BABGGDDB">HTP Package</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_programs023.htm#BABCIACB">UTL_FILE Package</a></li></ul>
					</ul>
				</ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_triggers.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers.htm"> Using Triggers </a></li><ul style="display:none;" id="xedev_triggers.htm" htmldb:listlevel="1"><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_triggers_ovrw.htm-BABDCADA')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers_ovrw.htm#BABDCADA">Overview of Triggers</a></li><ul style="display:none;" id="xedev_triggers_ovrw.htm-BABDCADA" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers001.htm#i1006273">Types of Triggers </a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers002.htm#BABFEBFG">Naming Triggers </a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers003.htm#BABGEFJI">When Is a Trigger Fired? </a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_triggers004.htm-BABGEIJC')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers004.htm#BABGEIJC">Controlling When a Trigger Is Fired </a></li><ul style="display:none;" id="xedev_triggers004.htm-BABGEIJC" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers004.htm#BABGJFGH">Firing Triggers With the BEORE and AFTER Options</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers004.htm#BABGHACJ">Firing Triggers With the FOR EACH ROW Option </a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers004.htm#BABDIIIF">Firing Triggers Based on Conditions (WHEN Clause) </a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers005.htm#BABIEFJG">Accessing Column Values in Row Triggers </a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers006.htm#BABBEEBC">Detecting the DML Operation That Fired a Trigger</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers007.htm#BABHICJD">Enabled and Disabled Trigger Modes</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers008.htm#BABHJCAB">Error Conditions and Exceptions in the Trigger Body </a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_triggers_design.htm-i1006211')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers_design.htm#i1006211">Designing Triggers</a></li><ul style="display:none;" id="xedev_triggers_design.htm-i1006211" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers009.htm#BABEBDCA">Guidelines For Triggers</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers010.htm#BABGFAED">Restrictions For Creating Triggers </a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers011.htm#BABBIEFA">Privileges Needed to Work with Triggers </a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_triggers_manage.htm-BGBBCDDA')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers_manage.htm#BGBBCDDA">Managing Triggers in the Database</a></li><ul style="display:none;" id="xedev_triggers_manage.htm-BGBBCDDA" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers012.htm#BABFBCGB">Creating a Trigger With the SQL Commands Page</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers013.htm#BABHAGEA">Creating a Trigger With the Object Browser Page</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers014.htm#BABCDHEA">Viewing a Trigger With Object Browser</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers015.htm#BABFGDFH">Creating a Trigger With the AFTER and FOR EACH ROW Option</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers016.htm#BABBJFJJ">Creating a Trigger With the BEFORE Option and WHEN Clause</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers017.htm#BABDHDHH">Creating a Trigger With an Exception Handler</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers018.htm#BABCIIEI">Creating a Trigger That Fires Once For Each Update</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers019.htm#BABEHFCE">Creating LOGON and LOGOFF Triggers</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers020.htm#i1007033">Modifying Triggers </a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers021.htm#BABBFDBG">Dropping Triggers</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers022.htm#BABIACHF">Disabling Triggers </a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers023.htm#BABEFFDH">Enabling Triggers </a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_triggers024.htm-i1006994')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers024.htm#i1006994">Compiling Triggers </a></li><ul style="display:none;" id="xedev_triggers024.htm-i1006994" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers024.htm#BABHEEHF">Trigger Errors</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers024.htm#BABCFFHB">Dependencies for Triggers </a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_triggers024.htm#BABGFDFB">Recompiling Triggers </a></li></ul>
					</ul>
				</ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global.htm"> Working in a Global Environment </a></li><ul style="display:none;" id="xedev_global.htm" htmldb:listlevel="1"><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global_ovrw.htm-CIHDCDGH')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global_ovrw.htm#CIHDCDGH">Overview of Globalization Support</a></li><ul style="display:none;" id="xedev_global_ovrw.htm-CIHDCDGH" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global001.htm#CIHFAEHJ">Globalization Support Features</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global002.htm#CIHCFAGJ">Running the Examples</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global_setup.htm-CIHCGJEI')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global_setup.htm#CIHCGJEI">Setting Up the Globalization Support Environment</a></li><ul style="display:none;" id="xedev_global_setup.htm-CIHCGJEI" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global003.htm#i1006280">Choosing a Locale with the NLS_LANG Environment Variable</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global004.htm#i1005949">Setting NLS Parameters</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global005.htm-i1006469')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global005.htm#i1006469">Language and Territory Parameters</a></li><ul style="display:none;" id="xedev_global005.htm-i1006469" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global005.htm#i1006480">NLS_LANGUAGE Parameter</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global005.htm#i1006575">NLS_TERRITORY Parameter</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global006.htm-i1006741')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global006.htm#i1006741">Date and Time Parameters</a></li><ul style="display:none;" id="xedev_global006.htm-i1006741" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global006.htm#i1006753">Date Formats</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global006.htm#i1006971">Time Formats</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global007.htm-i1007190')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global007.htm#i1007190">Calendar Definitions</a></li><ul style="display:none;" id="xedev_global007.htm-i1007190" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global007.htm#i1007202">Calendar Formats</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global007.htm#i1007644">NLS_CALENDAR Parameter</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global008.htm-i1007693')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global008.htm#i1007693">Numeric and List Parameters</a></li><ul style="display:none;" id="xedev_global008.htm-i1007693" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global008.htm#i1007705">Numeric Formats</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global008.htm#i1007759">NLS_NUMERIC_CHARACTERS Parameter</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global009.htm-i1007815')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global009.htm#i1007815">Monetary Parameters</a></li><ul style="display:none;" id="xedev_global009.htm-i1007815" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global009.htm#i1007847">Currency Formats</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global009.htm#i1007887">NLS_CURRENCY Parameter</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global009.htm#i1007944">NLS_ISO_CURRENCY Parameter</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global009.htm#i1008039">NLS_DUAL_CURRENCY Parameter</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global010.htm-i1008368')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global010.htm#i1008368">Linguistic Sorting and Searching</a></li><ul style="display:none;" id="xedev_global010.htm-i1008368" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global010.htm#i1008393">NLS_SORT Parameter</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global010.htm#i1008458">NLS_COMP Parameter</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global010.htm#CIHHFHIB">Case-Insensitive and Accent-Insensitive Searching</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global011.htm-i1008561')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global011.htm#i1008561">Length Semantics</a></li><ul style="display:none;" id="xedev_global011.htm-i1008561" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global011.htm#i1008570">NLS_LENGTH_SEMANTICS Parameter</a></li></ul>
					</ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global_programming.htm-CIHJCBHI')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global_programming.htm#CIHJCBHI">SQL and PL/SQL Programming with Unicode</a></li><ul style="display:none;" id="xedev_global_programming.htm-CIHJCBHI" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global012.htm#CIHDJHAG">Overview of Unicode</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global013.htm-i1006072')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global013.htm#i1006072">SQL NCHAR Datatypes</a></li><ul style="display:none;" id="xedev_global013.htm-i1006072" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global013.htm#CIHCDIAB">NCHAR Datatype</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global013.htm#i1006105">NVARCHAR2 Datatype</a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global014.htm#i1006315">Unicode String Literals</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global015.htm#CIHGJBFI">NCHAR Literal Replacement</a></li></ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_global_locale.htm-CIHHEACF')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global_locale.htm#CIHHEACF">Locale-Dependent SQL Functions with Optional NLS Parameters</a></li><ul style="display:none;" id="xedev_global_locale.htm-CIHHEACF" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global016.htm#CIHGBBBA">Default Values for NLS Parameters in SQL Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global017.htm#i1005962">Specifying NLS Parameters in SQL Functions</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_global018.htm#i1006071">Unacceptable NLS Parameters in SQL Functions</a></li></ul>
				</ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sqlplus.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus.htm"> Using SQL Command Line</a></li><ul style="display:none;" id="xedev_sqlplus.htm" htmldb:listlevel="1"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_overview.htm#CJAGHDHG">Overview of SQL Command Line</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sqlplus_using.htm-BJEEGJGJ')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_using.htm#BJEEGJGJ">Using SQL Command Line</a></li><ul style="display:none;" id="xedev_sqlplus_using.htm-BJEEGJGJ" htmldb:listlevel="2"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_start_exit.htm#BJECGGFH">Starting and Exiting SQL Command Line</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_help.htm#BJEIEGBF">Displaying Help With SQL Command Line</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_enter_exec.htm#CJAGGHGE">Entering and Executing SQL Statements and Commands</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_describe.htm#BJEEGAII">SQL Command Line DESCRIBE Command</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_set_command.htm#BJEJEJIA">SQL Command Line SET Commands</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_run_scripts.htm#CJAGIECA">Running Scripts From SQL Command Line</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_spool.htm#CJAIGGED">Spooling From SQL Command Line</a></li><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_sqlplus_use_variables.htm-BJEFFIFB')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_use_variables.htm#BJEFFIFB">Using Variables With SQL Command Line</a></li><ul style="display:none;" id="xedev_sqlplus_use_variables.htm-BJEFFIFB" htmldb:listlevel="3"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_use_variables.htm#BJEJJBFI">Prompting for a Variable Value in a Query</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_use_variables.htm#CJADBIJC">Reusing a Variable Value in a Query</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_sqlplus_use_variables.htm#BJECDCAA">Defining a Variable Value for a Query</a></li></ul>
					</ul>
				</ul><li><img src="plus.jpg" class="e" onclick="HT(this,'xedev_reswords.htm')"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_reswords.htm"> Reserved Words</a></li><ul style="display:none;" id="xedev_reswords.htm" htmldb:listlevel="1"><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_reswords001.htm#BABEJIII">SQL Reserved Words</a></li><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/xedev_reswords002.htm#BABBAAHE">PL/SQL Reserved Words</a></li></ul><li><img src="d.jpg"><a target="chapContent" onclick="MC(this)" href="../doc/XEDEV/index.htm">Index</a></li></ul>
		</div>
	</body></html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de