You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for SUM


1 to 20 of 373 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 120 of 177

SUMSyntax sum::= Text description of sum See Also: "Analytic Functions" for information on syntax … , semantics, and restrictions Purpose SUM returns the sum of values of expr. You can use it as an … The following example calculates the sum of all salaries in the sample hr.employees table: SELECT SUM

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Aggregating Data, 5 of 12

Sum ( SUM )Scaled Sum ( SSUM )

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Aggregating Data, 5 of 12

Weighted Sum ( WSUM )Average ( AVERAGE )

Application Developer's Guide - Workspace Manager, 9i Release 2 (9.2.0.2)

Error Messages

WM_ERROR_177 sum of length of all column names of 'string'. 'string' exceeds 8250 charactersCause: An attempt was made to version-enable a table where the sum of the column name lengths … exceeded 8250 characters. Action: Rename some of the table's columns to reduce the sum of the column name lengths.

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02143 SUM(expr) without COUNT(expr)Cause: SUM(expr) occurs in the select list without a corresponding COUNT(expr). Action: Add COUNT(expr) to the select list.

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

STDDEV_SAMPSUM VAR_POP VAR_SAMP

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

STDDEV_SAMP *SUM * VAR_POP * VAR_SAMP *

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30454 summary contains STDDEV without corresponding SUM & COUNTCause: Incremental refresh of summaries with STDDEV(X) requires COUNT(X) and SUM(X) columns to be

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02131 agg(expr) requires corresponding SUM(expr) functionaggregate functions but omits an invocation of the SUM function on the same argument. Action: Add the SUM function to the select list.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30455 summary contains VARIANCE without corresponding SUM & COUNTCause: Incremental refresh of summaries with VARIANCE(X) requires COUNT(X) and SUM(X) columns to be

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02140 agg(expr) requires corresponding SUM(expr*expr) functionaggregate functions but omits an invocation of the SUM function on the square of the same argument (the … argument multiplied by itself). Action: Add the SUM function on the square of the argument.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14056 partition number string : sum of PCTUSED and PCTFREE may not exceed 100Cause: The sum of PCTUSED and PCTFREE for a partition whose number (partitions are numbered … not specified, system defaults would be used. Action: Ensure that a sum of PCTUSED and PCTFREE for the partition does not exceed 100.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-02100 to ORA-04099

ORA-04000 the sum of PCTUSED and PCTFREE cannot exceed 100Cause: The sum of PCTUSED and PCTFREE for a cluster or table exceeds 100. Action: Create the table … /cluster specifying values whose sum is less than or equal to 100.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14161 subpartition number string : sum of PCTUSED and PCTFREE may not exceed 100Cause: The sum of PCTUSED and PCTFREE for a subpartition whose number (subpartitions are numbered … explicitly, system defaults would be used. Action: Ensure that a sum of PCTUSED and PCTFREE for the subpartition does not exceed 100.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14057 partition " string ": sum of PCTUSED and PCTFREE may not exceed 100Cause: The sum of PCTUSED and PCTFREE for a partition whose name (explicitly specified by the user … specified, system defaults would be used. Action: Ensure that a sum of PCTUSED and PCTFREE for the partition does not exceed 100.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Net Messages (TNS)

TNS-01174 The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAXCause: The minimum value for PRESPAWN_MAX should be the sum of the POOL_SIZEs. Action: Be sure the

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14162 subpartition " string ": sum of PCTUSED and PCTFREE may not exceed 100Cause: The sum of PCTUSED and PCTFREE for a subpartition whose name (explicitly specified by the … , system defaults would be used. Action: Ensure that a sum of PCTUSED and PCTFREE for the subpartition does not exceed 100.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-29375 sum of percentages string for level string, plan string exceeds stringCause: The sum of percentages for the specified plan, level exceeds 100. Action: Alter the percentages for the level so that they sum to 100.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Oracle Database Event Tests

Data Source(Gets/Misses) * 100 where: Misses: select sum(getmisses) from v$rowcache Gets: select sum(gets) from v$rowcache

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30452 cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)refresh AVG(X). It requires both SUM(X) and COUNT(X) columns in order to in refresh STDDEV(X) or VARIANCE