📄 array.ob.tags.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=iso-8859-1">
<META NAME="GENERATOR" Content="Visual Page 1.0 for Windows">
<TITLE>array.obj.tag</TITLE>
</HEAD>
<BODY BACKGROUND="bar_products.gif" bgcolor="white">
<UL>
<UL>
<IMG SRC="Array.GIF" WIDTH="431" HEIGHT="92" ALIGN="BOTTOM" BORDER="0">
<HR ALIGN="CENTER">
<P><FONT SIZE="5">Table of Contents</FONT></P>
<P>
<UL>
<LI><A HREF="#col"><B>COL</B></A>
<LI><A HREF="#cons"><B>CONS</B></A>
<LI><A HREF="#conscol"><B>CONSCOL</B></A>
<LI><A HREF="#curs"><B>CURS</B></A>
<LI><A HREF="#dbobjects"><B>DBOBJECTS</B></A>
<LI><A HREF="#desccol"><B>DESCCOL</B></A>
<LI><A HREF="#fky"><B>FKY</B></A>
<LI><A HREF="#fkycol"><B>FKYCOL</B></A>
<LI><A HREF="#fkydesc"><B>FKYDESC</B></A>
<LI><A HREF="#fkydesccol"><B>FKYDESCCOL</B></A>
<LI><A HREF="#gencol"><B>GENCOL</B></A>
<LI><A HREF="#ind"><B>IND</B></A>
<LI><A HREF="#indcol"><B>INDCOL</B></A>
<LI><A HREF="#invalid"><B>INVALID_IDENTS</B></A>
<LI><A HREF="#nonpkycol"><B>NONPKYCOL</B></A>
<LI><A HREF="#pkycol"><B>PKYCOL</B></A>
<LI><A HREF="#uconscol"><B>UCONSCOL</B></A>
<LI><A HREF="#uind"><B>UIND</B></A>
<LI><A HREF="#uindcol"><B>UINDCOL</B></A>
<LI><A HREF="#updcol"><B>UPDCOL</B></A>
</UL>
<HR ALIGN="CENTER">
<P><FONT SIZE="4" FACE="Arial">Available Array Object Tags</FONT></P>
<HR ALIGN="CENTER">
<P>The object tags available within each array for the Table Encapsulation driver (used as the source for the default
TEST driver you will be creating) are shown in the following table:</P>
<TABLE BORDER="1" CELLPADDING="7" CELLSPACING="1" WIDTH="693" HEIGHT="8130" BORDERCOLOR="#000000">
<TR>
<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#000000"><B><BR>
<BR>
</B><FONT COLOR="#FFFFFF"><B>Array</B></FONT></TD>
<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#000000"><B><BR>
<BR>
</B><FONT COLOR="#FFFFFF"><B>Object Tag</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#000000"><B><BR>
<BR>
</B><FONT COLOR="#FFFFFF"><B>Description</B></FONT></TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"><A NAME="col"></A><FONT SIZE="2" FACE="Courier New"><B><BR>
COL</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 upper case.</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>colname</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">The name of the column in lower case.</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>data_type</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">The name of the datatype of the column, in upper case.</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>coldatatype</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">The name of the datatype of the column, in lower case.</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>data_length</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Length of the column in bytes</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>default_length</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Length of default value for the column</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>data_precision</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Length of decimal digits (NUMBER) or binary digits (FLOAT)</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><FONT SIZE="2" FACE="Courier New"><B>data_declaration</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Valid datatype declaration for the column</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>nullable</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Y if a nullable column, other N</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>data_default</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">The default value for the column</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>comments</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Column comment</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>constraint_name</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Name of the constraint of which this column is a part</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>constraint_type</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Type of the constraint of which this column is a part</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>pky_position</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">The position of this column in the table's primary key</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>pky_table_name</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">INTERNAL USER ONLY</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP" BGCOLOR="#FFFFFF"> </TD>
<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF"> </TD>
<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF"> </TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"><A NAME="cons"></A><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>CONS</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 associated with constraint definition</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>converted_constraint_name</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">The constraint name pre-pended with "NOT_NULL_" if this is a NOT NULL constraint.</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>constraint_type</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Type of constraint (P for Primary Key, R for Foreign Key, C for check constraint)</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>table_name</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Name associated with table with constraint definition</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>search_condition</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Text of search condition for table check</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>converted_ search_condition</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Text of search condition for table check in which column names are substituted with generated argument names</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>r_owner</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Owner of table used in referential constraint</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>r_constraint_name</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Name of unique constraint definition for referenced table</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>delete_rule</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">The delete rule for a referential constrain</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>status</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Enforcement status of constraint - ENABLED or DISABLED</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>not_null</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">TRUE if this is a NOT NULL check constraint</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><FONT SIZE="2" FACE="Courier New"><B>column_count</B></FONT></TD>
<TD WIDTH="68%" VALIGN="TOP">Number of columns referenced in the constraint search condition</TD>
</TR>
<TR>
<TD WIDTH="13%" VALIGN="TOP"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><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"> </TD>
<TD WIDTH="18%" VALIGN="TOP"><B><BR>
<BR>
</B><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" BGCOLOR="#FFFFFF"> </TD>
<TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#FFFFFF"> </TD>
<TD WIDTH="68%" VALIGN="TOP" BGCOLOR="#FFFFFF"> </TD>
</TR>
<TR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -