array.ob.tags.htm

Oracle PL/SQL procedure generator (second generator type)

				<TD WIDTH="13%" VALIGN="TOP"><A NAME="conscol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>CONSCOL</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>column_name</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The name of the column in the constraint</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>converted_column_name</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The name of the column in the constraint substituted with its generated argument name. For example, last_name -&gt;
					last_name_in</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>abs_position</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP"><A NAME="curs"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>CURS</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>drv</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The name of the driver for which this cursor is defined.</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>curname</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The name of the cursor</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>collist</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The column (and expression) list used in the SELECT statement of the cursor</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>objid</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP"><A NAME="dbobjects"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>DBOBJECT</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>owner</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The owner of the object</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>objectname</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The name of the object</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>objecttype</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The type of the object</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP"><A NAME="desccol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>DESCCOL</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>See INDCOL</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Same tags as INDCOL</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP"><A NAME="fky"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>FKY</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>constraint_name or fkyname</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Name of the foreign key</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>constraint_type</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The value &quot;R&quot;</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>table_name</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The table on which this foreign key is defined.</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>pky_owner</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Owner of the table for which this foreign key is the primary key</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>pky_table_name or pkytabname</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The name of the table for which this foreign key is the primary key</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>pky_column_name or fkypkycolname</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">If a single column constraint, the name of the column in the table for which this foreign key is the primary key</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>pky_constraint_name</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Name of the constraint for which this foreign key is the primary key</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>column_count</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Number of columns in the foreign key</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>starting_row</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>cumulative_column_count</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>comment</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Column comment; can also be used to store information used during generation</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>fkydescindex</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>fkydescfunctype</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>fkydescfunc</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>tabwithdesc</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP"><A NAME="fkycol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>FKYCOL</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>column_name</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Name of column in foreign key</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>position</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Position of column in foreign key</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>pky_column_name</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Name of column in constraint for which this foreign key is the primary key</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>abs_position</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP"><A NAME="fkydesc"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>FKYDESC</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>See IND</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Same tags as IND</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP"><A NAME="fkydesccol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>FKYDESCCOL</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>See INDCOL</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Same tags as INDCOL</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
				<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF">&nbsp;</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP"><A NAME="gencol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>GENCOL</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>colname</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Name of column</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>coldatatype</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Datatype of column</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>colnullable</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">TRUE if column is nullable</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>desccol</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>tabdesc</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>coldmlval</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Value used in DML statements (different from column value if function is applied to the column)</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>