PORTION 保留 保留 POSITION 非保留(不能作为函数名/类型名) 保留 保留 保留 POSITION_REGEX 保留 保留 POWER 保留 保留 PRECEDES 保留 保留 PRECEDING 非保留 非保留 非保留 PRECISION 非保留(不能作为函数名/类型名) 保留 保留 保留 PREPARE 非保留 保留 保留
第二个函数,官方文档的解释是这样的This function replaces a single portion of a given fragment of XML markup xml_target with a new XML fragment new_xml, and then returns the changed XML. The portion of xml_target that is replaced matches an XPath expression xpath_expr supplied by the user....
b、UTL_FILE中相关过程函数的功能说明 FCLOSE Procedure Closes a file FCLOSE_ALL Procedure Closes all open file handles FCOPY Procedure Copies a contiguous portion of a file to a newly created file FFLUSH Procedure Physically writes all pending output to a file FGETATTR Procedure Reads and returns...
SQL_TIMESTAMP、SQL_TINYINT、 SQL_TSI_DAY、SQL_TSI_FRAC_SECOND、SQL_TSI_HOUR、SQL_TSI_MICROSECOND、SQL_TSI_MINUTE、SQL_TSI_MONTH、 SQL_TSI_QUARTER、 SQL_TSI_SECOND、SQL_TSI_WEEK、SQL_TSI_YEAR、SQL_VARBINARY、SQL_VARCHAR、STATE、STATEMENT、STRING_AGG、STRUCTURE、STYLE、SUBCLASS_ORIGIN、...
The following example creates a typeUtf8Stringthat references classutf8stringin the assemblyutf8string. Before creating the type, assemblyutf8stringis registered in the local database. Replace the binary portion of theCREATE ASSEMBLYstatement with a valid description. ...
The following query can be used to identify the dependent tables that require incremental maintenance, where <schema name> is the qualifier oftable-nameand is the table name portion oftable-name. WITH DEP_CNT(TOTAL_DEP) AS (SELECT COUNT(*) FROM SYSCAT.TABDEP...
INITCAP –Returns a converted version of the input string such that the first character of each space-delimited word is uppercase, and all other characters are lowercase. LOWER/UPPER –Converts a string to lowercase or uppercase. OVERLAY –Replaces a portion of the first string argument (...
If an attempt to divide a row at column_name causes the size of the index portion of the row to exceed the PCTTHRESHOLD value (either specified or default), Oracle breaks up the row based on the PCTTHRESHOLD value. supplemental_logging_props The supplemental_logging_props clause lets you ...
The longest pattern or patterns from the <simple_term> are matched against the thesaurus and additional terms are generated to expand or replace the original pattern. If a match is not found for all or part of the <simple_term>, the non-matching portion is treated as a simple_term. For...
Cause: A SQL string has been associated with both a column object and one of it's attributes in the control file. Because the SQL string of the column object will replace the entire column object in the VALUE clause of the INSERT statement, the SQL string of the attribute is ignored. Th...