array.ob.tags.htm

Oracle PL/SQL procedure generator (second generator type)

				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>fkpkgname</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>defcolval</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Default value of column</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>colhasdef</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">TRUE if column has default value</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>pkdesccol</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>parmcoldef</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Default value used in parameter list for this column</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="ind"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>IND</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>owner</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Owner of index</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">Table on which the index is defined</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>table_owner</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Owner of table on which the index is defined</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>index_name or indname</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Name of index</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>table_type</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Type of table</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>uniqueness</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Uniqueness status of the index: &quot;UNIQUE&quot; or &quot;NONUNIQUE&quot;</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 index</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_count</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="indcol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>INDCOL</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 index</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>column_position</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Position of column in index</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>column_length</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Indexed length of the column</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="invalid"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>INVALID_IDENTS</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>driver</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Driver for which invalid identifier was found</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>owner</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Schema from which the generation occurred</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>name</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Name of object from which generation occurred</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>type</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Type of object from which generation occurred</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>alias</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Alias from which identifier was constructed</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>alias_description</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Description of alias</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>ident</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Identifier that was invalid</TD>
			</TR>
			<TR>
				<TD WIDTH="13%" VALIGN="TOP">&nbsp;</TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>new_ident</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Corrected form of identifier</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="nonpkycol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>NONPKYCOL</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>See GENCOL</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Same tags as GENCOL</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="pkycol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>PKYCOL</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>constraint_name</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Name of 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_name</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>constraint_type</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">The letter &quot;P&quot;</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 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_id</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Column ID from data dictionary view</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="uconscol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>UCONSCOL</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>See GENCOL</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Same tags as GENCOL</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="uind"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>UIND</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="uindcol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>UINDCOL</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="updcol"></A><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>UPDCOL</B></FONT></TD>
				<TD WIDTH="18%" VALIGN="TOP"><B><BR>
					<BR>
					</B><FONT SIZE="2" FACE="Courier New"><B>See GENCOL</B></FONT></TD>
				<TD WIDTH="68%" VALIGN="TOP">Same tags as GENCOL</TD>
			</TR>
		</TABLE>

	</UL>
</UL>


</BODY>

</HTML>