syntax.htm

Oracle PL/SQL procedure generator (second generator type)

					</B><FONT COLOR="#FFFFFF"><B>Description</B></FONT></TD>
			</TR>
			<TR>
				<TD      VALIGN="TOP"><A NAME="col"></A><FONT SIZE="2" FACE="Courier New"><B>
					COL</B></FONT></TD>
				<TD      VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>column_name</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">The name of the column in upper case.</TD>
			</TR>
			<TR>
				<TD      VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>colname</B></FONT></TD>
				<TD    WIDTH="15%" VALIGN="TOP">The name of the column in lower case.</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>data_type</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">The name of the datatype of the column, in upper case.</TD>
			</TR>
			<TR>
				<TD      VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>coldatatype</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">The name of the datatype of the column, in lower case.</TD>
			</TR>
			<TR>
				<TD      VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>data_length</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">Length of the column in bytes</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>default_length</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">Length of default value for the column</TD>
			</TR>
			<TR>
				<TD         VALIGN="TOP">&nbsp;</TD>
				<TD         VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>data_precision</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">Length of decimal digits (NUMBER) or binary digits (FLOAT)</TD>
			</TR>
			<TR>
				<TD         VALIGN="TOP">&nbsp;</TD>
				<TD         VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>data_declaration</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">Valid datatype declaration for the column</TD>
			</TR>
			<TR>
				<TD         VALIGN="TOP">&nbsp;</TD>
				<TD         VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>nullable</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">Y if a nullable column, other N</TD>
			</TR>
			<TR>
				<TD         VALIGN="TOP">&nbsp;</TD>
				<TD         VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>data_default</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">The default value for the column</TD>
			</TR>
			<TR>
				<TD         VALIGN="TOP">&nbsp;</TD>
				<TD         VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>comments</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">Column comment</TD>
			</TR>
			<TR>
				<TD         VALIGN="TOP">&nbsp;</TD>
				<TD         VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>constraint_name</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">Name of the constraint of which this column is a part</TD>
			</TR>
			<TR>
				<TD         VALIGN="TOP">&nbsp;</TD>
				<TD         VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>constraint_type</B></FONT></TD>
				<TD     WIDTH="15%" VALIGN="TOP">Type of the constraint of which this column is a part</TD>
			</TR>
			<TR>
				<TD       VALIGN="TOP">&nbsp;</TD>
				<TD       VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>pky_position</B></FONT></TD>
				<TD      VALIGN="TOP">The position of this column in the table's primary key</TD>
			</TR>
			<TR>
				<TD      VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>pky_table_name</B></FONT></TD>
				<TD      VALIGN="TOP">INTERNAL USER ONLY</TD>
			</TR>
						<TR>
				<TD      VALIGN="TOP"><A NAME="cons"></A><B>
					
					</B><FONT SIZE="2" FACE="Courier New"><B>CONS</B></FONT></TD>
				<TD      VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>constraint_name</B></FONT></TD>
				<TD      VALIGN="TOP">Name associated with constraint definition</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>converted_constraint_name</B></FONT></TD>
				<TD      VALIGN="TOP">The constraint name pre-pended with &quot;NOT_NULL_&quot; if this is a NOT NULL constraint.</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>constraint_type</B></FONT></TD>
				<TD      VALIGN="TOP">Type of constraint (P for Primary Key, R for Foreign Key, C for check constraint)</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>table_name</B></FONT></TD>
				<TD      VALIGN="TOP">Name associated with table with constraint definition</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>search_condition</B></FONT></TD>
				<TD      VALIGN="TOP">Text of search condition for table check</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>converted_ search_condition</B></FONT></TD>
				<TD      VALIGN="TOP">Text of search condition for table check in which column names are substituted with generated argument names</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>r_owner</B></FONT></TD>
				<TD      VALIGN="TOP">Owner of table used in referential constraint</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>r_constraint_name</B></FONT></TD>
				<TD      VALIGN="TOP">Name of unique constraint definition for referenced table</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>delete_rule</B></FONT></TD>
				<TD      VALIGN="TOP">The delete rule for a referential constrain</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>status</B></FONT></TD>
				<TD      VALIGN="TOP">Enforcement status of constraint - ENABLED or DISABLED</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>not_null</B></FONT></TD>
				<TD      VALIGN="TOP">TRUE if this is a NOT NULL check constraint</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>column_count</B></FONT></TD>
				<TD      VALIGN="TOP">Number of columns referenced in the constraint search condition</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>cumulative_column_count</B></FONT></TD>
				<TD      VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>starting_row</B></FONT></TD>
				<TD      VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
						<TR>
				<TD     VALIGN="TOP"><A NAME="conscol"></A><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>CONSCOL</B></FONT></TD>
				<TD      VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>column_name</B></FONT></TD>
				<TD      VALIGN="TOP">The name of the column in the constraint</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD      VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>converted_column_name</B></FONT></TD>
				<TD     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     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>abs_position</B></FONT></TD>
				<TD     VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
						<TR>
				<TD     VALIGN="TOP"><A NAME="curs"></A><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>CURS</B></FONT></TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>drv</B></FONT></TD>
				<TD     VALIGN="TOP">The name of the driver for which this cursor is defined.</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>curname</B></FONT></TD>
				<TD     VALIGN="TOP">The name of the cursor</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>collist</B></FONT></TD>
				<TD     VALIGN="TOP">The column (and expression) list used in the SELECT statement of the cursor</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>objid</B></FONT></TD>
				<TD     VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
					<TR>
				<TD     VALIGN="TOP"><A NAME="dbobjects"></A><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>DBOBJECT</B></FONT></TD>
				<TD     VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>owner</B></FONT></TD>
				<TD     VALIGN="TOP">The owner of the object</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>objectname</B></FONT></TD>
				<TD     VALIGN="TOP">The name of the object</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>objecttype</B></FONT></TD>
				<TD     VALIGN="TOP">The type of the object</TD>
			</TR>
						<TR>
				<TD     VALIGN="TOP"><A NAME="desccol"></A><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>DESCCOL</B></FONT></TD>
				<TD     VALIGN="TOP"><B>
					</B><FONT SIZE="2" FACE="Courier New"><B><a href="#indcol">See INDCOL</a></B></FONT></TD>
				<TD     VALIGN="TOP"><a href="#indcol">Same tags as INDCOL</a></TD>
			</TR>
						<TR>
				<TD     VALIGN="TOP"><A NAME="fky"></A><B>
					</B><FONT SIZE="2" FACE="Courier New"><B>FKY</B></FONT></TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>constraint_name or fkyname</B></FONT></TD>
				<TD     VALIGN="TOP">Name of the foreign key</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>constraint_type</B></FONT></TD>
				<TD     VALIGN="TOP">The value &quot;R&quot;</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>table_name</B></FONT></TD>
				<TD     VALIGN="TOP">The table on which this foreign key is defined.</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>pky_owner</B></FONT></TD>
				<TD     VALIGN="TOP">Owner of the table for which this foreign key is the primary key</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     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     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>pky_column_name or fkypkycolname</B></FONT></TD>
				<TD     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     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>pky_constraint_name</B></FONT></TD>
				<TD     VALIGN="TOP">Name of the constraint for which this foreign key is the primary key</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>column_count</B></FONT></TD>
				<TD     VALIGN="TOP">Number of columns in the foreign key</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>starting_row</B></FONT></TD>
				<TD     VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>cumulative_column_count</B></FONT></TD>
				<TD     VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>comment</B></FONT></TD>
				<TD     VALIGN="TOP">Column comment; can also be used to store information used during generation</TD>
			</TR>
			<TR>
				<TD     VALIGN="TOP">&nbsp;</TD>
				<TD     VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>fkydescindex</B></FONT></TD>
				<TD     VALIGN="TOP">INTERNAL USE ONLY</TD>
			</TR>