Results for HAVING


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


Guide, 10g Release 1 (10.1)

20 SQL for Aggregation in Data Warehouses

HAVING Clause Used with GROUP BY ExtensionsThe HAVING clause of SELECT statements is unaffected by the use of GROUP BY. Note that the … conditions specified in the HAVING clause apply to both the subtotal and non-subtotal rows of the result set … HAVING clause. This can be achieved by using a GROUPING or GROUPING_ID function together with the HAVING

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02011: a HAVING clause is present: Re-phrase the query to avoid the non-equijoin. QSM-02011: a HAVING clause is present

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-01059: HAVING clause in the query block is malformedview. This usually requires a join back to a third table. Action: none QSM-01059: HAVING clause in the query block is malformed

Error Messages, 10g Release 1 (10.1)

57 PCC-02010 to PCC-02451

PCC-02437: Expecting an expression having binary integral typeDESCRIBE statement. PCC-02437: Expecting an expression having binary integral type

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-01060: illegal subquery in the HAVING clauseCause: An illegal HAVING clause has been specified in the query. Action: Correct the query syntax … and run the query again. QSM-01060: illegal subquery in the HAVING clause

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00119: Duplicate having-clause in table expression… PLS-00119: Duplicate having-clause in table expression

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02034: no joins are present in the HAVING clauseselection conditions in the WHERE clause. Action: Add a filter condition. QSM-02034: no joins are present in the HAVING clause

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02017: subquery present in the HAVING clauseclustered table in the FROM list. Action: Remove the reference to the clustered table in the FROM list. QSM-02017: subquery present in the HAVING clause

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-22981: must specify a table/view having system generated OIDobject identifier for the object view. ORA-22981: must specify a table/view having system generated OID

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02106: mv uses a filter condition in the WHERE or HAVING clauseaggregate function in a filter condition in the HAVING clause. Action: Re-phrase the query to avoid the use … of aggregates in filter conditions in the HAVING clause. QSM-02106: mv uses a filter condition in the WHERE or HAVING clause

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02104: aggregate function in a filter condition in the HAVING clause: aggregate function in a filter condition in the HAVING clause

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02035: no filter conditions are present in the HAVING clausethe HAVING clause. Action: Re-phrase the query to include a join. QSM-02035: no filter conditions are present in the HAVING clause

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-01113: HAVING clause of mv, string, is more restrictive than query… QSM-01113: HAVING clause of mv, string, is more restrictive than query

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02008: non-join filter condition in WHERE or HAVING clauseinstance, QSM-02008: non-join filter condition in WHERE or HAVING clause

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause: none PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

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

110 DBMS_TTS

Security ModelOnly users having the execute_catalog_role can execute this procedure. This role is initially only assigned to user SYS.

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Setting Up Enterprise Manager Preferencesdatabase. To avoid having to enter this information every time you create a job or task, Enterprise

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

161 UTL_RAW

Return Valueshaving the same data as the input RAW. NULL If r input parameter was NULL.

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

161 UTL_RAW

Return Valueshaving the same data as the input RAW. NULL If r input parameter was NULL.

Developer's Guide to the OLAP API, 10g Release 1 (10.1)

4 Discovering the Available Metadata

4.5 Getting the Characteristics of Metadata ObjectsHaving discovered the list of MdmMeasure and MdmDimension objects, the next step in metadata


Was this page helpful?