Results for SUM


1 to 20 of 369 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

SUM

SUMSyntax sum::= Description of the illustration sum.gif See Also: "Analytic Functions " for … information on syntax, semantics, and restrictions Purpose SUM returns the sum of values of expr. You can use … "Aggregate Functions " Aggregate Example The following example calculates the sum of all salaries in … the

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02143: SUM(expr) without COUNT(expr)Cause: The materialized view query omits COUNT(*) from the select list. Action: Add COUNT(*) to the select list. QSM-02143: SUM(expr) without COUNT(expr)

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-30454: summary contains STDDEV without corresponding SUM & COUNTif incremental refresh capability is desired. ORA-30454: summary contains STDDEV without corresponding SUM & COUNT

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-30455: summary contains VARIANCE without corresponding SUM & COUNTCause: Incremental refresh of summaries with STDDEV(X) requires COUNT(X) and SUM(X) columns to be … summary definition if incremental refresh capability is desired. ORA-30455: summary contains VARIANCE without corresponding SUM & COUNT

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02131: agg(expr) requires correspondng SUM(expr) function, complex expressions. Action: Re-phrase the query to simplify the expression. QSM-02131: agg(expr) requires correspondng SUM(expr) function

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02140: agg(expr) requires correspondng SUM(expr*expr) functionthe same argument. Action: Add the indicated aggregate function to the select list. QSM-02140: agg(expr) requires correspondng SUM(expr*expr) function

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14161: subpartition number string : sum of PCTUSED and PCTFREE may not exceed 100; TABLESPACE is the only valid option Action: remove invalid option(s) ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14057: partition " 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 ORA-14057: partition " string ": sum of PCTUSED and PCTFREE may not exceed 100

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100stack. ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-29375: sum of values string for level string, plan string exceeds stringdirectives if needed. Otherwise, delete the plan. ORA-29375: sum of values string for level string, plan string exceeds string

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14162: subpartition " 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 ORA-14162: subpartition " string ": sum of PCTUSED and PCTFREE may not exceed 100

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14056: partition number string : sum of PCTUSED and PCTFREE may not exceed 100-14056: partition number string: sum of PCTUSED and PCTFREE may not exceed 100

Error Messages, 10g Release 1 (10.1)

43 TNS-00000 to TNS-12699

TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX)(TIMEOUT=30)))) Add or correct these parameters in the LISTENER.ORA file TNS-01174: The sum of the

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)operation Action: Notify ORACLE support. ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

Type of Statistic Expression,2)/REGR_SXX))/(REGR_COUNT-2)) Total sum of squares REGR_SYY Regression sum of squares POWER … (REGR_SXY,2) / REGR_SXX Residual sum of squares REGR_SYY - ( POWER(REGR_SXY,2)/REGR_SXX) t statistic for

Packages and Types Reference, 10g Release 1 (10.1)

161 UTL_RAW

ExceptionsThere is an error if the sum of the lengths of the inputs exceeds the maximum allowable length for a RAW, which is 32767 bytes.

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

operator+=()This method assigns the sum of IntervalYM and val to IntervalYM. Syntax IntervalYM& operator

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

IntervalD S Class

operator+=()Assigns the sum of IntervalDS and val to IntervalDS. Syntax IntervalDS& operator+=( const

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

operator+()This method returns the sum of the intervals specified. Syntax const IntervalYM operator+( const

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

IntervalD S Class

operator+()Returns the sum of the intervals specified. Syntax const IntervalDS operator+( const IntervalDS





Was this page helpful?

Integrated Cloud Applications & Platform Services