Results for MINUS


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


Reference, 10g Release 1 (10.1)

3 Oracle Text CONTAINS Query Operators

MINUS (-)Use the MINUS operator to lower the score of documents that contain unwanted noise terms. MINUS is … minus term2 Returns documents that contain term1. Calculates score by subtracting the score of term2 … score of cars minus the score of Ford. Related Topics See Also: "NOT (~)"

Reference, 10g Release 1 (10.1)

H Stopword Transformations in Oracle Text

H.1.5 MINUS TransformationsStopword Expression Rewritten Expression non_stopword MINUS stopword non_stopword non_stopword … MINUS no_token non_stopword stopword MINUS non_stopword no_token no_token MINUS non_stopword no_token … stopword MINUS stopword no_token no_token MINUS stopword no_token stopword MINUS

SQL Reference, 10g Release 1 (10.1)

The UNION [ALL], INTERSECT, MINUS Operators

The UNION [ALL], INTERSECT, MINUS OperatorsYou can combine multiple queries using the set operators UNION, UNION ALL, INTERSECT, and MINUS … , or nested table. The UNION, INTERSECT, and MINUS operators are not valid on LONG columns. If the … product_id FROM inventories INTERSECT SELECT product_id FROM order_items; MINUS Example The following … statement combines results

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-01420: INTERSECT and MINUS set operators are not ANSIgrammar. Action: none PLS-01420: INTERSECT and MINUS set operators are not ANSI

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-04005: INCREMENT must be less than MAXVALUE minus MINVALUEthat is less than MAXVALUE ORA-04005: INCREMENT must be less than MAXVALUE minus MINVALUE

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00399: different types of columns in UNION, INTERSECT, or MINUS expressionCause: The SELECT clauses to the left and right of a UNION, INTERSECT, or MINUS expression do not … items. PLS-00399: different types of columns in UNION, INTERSECT, or MINUS expression

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00398: wrong number of columns in UNION, INTERSECT, or MINUS expressionfunctions. PLS-00398: wrong number of columns in UNION, INTERSECT, or MINUS expression

Reference, 10g Release 1 (10.1)

3 Oracle Text CONTAINS Query Operators

3.1.1 Group 1 Operatorsprecedence to lowest: EQUIValence (=) NEAR (;) weight (*), threshold (>) MINUS (-) NOT (~) WITHIN AND (&) OR (|) ACCUMulate (, )

DML Reference, 10g Release 1 (10.1)

PARENS

PARENSminus sign. Data type BOOLEAN Syntax PARENS = {YES| NO } Arguments

Performance Tuning Guide, 10g Release 1 (10.1)

17 Optimizer Hints

The ALL_ROWS hint explicitly chooses the query optimization approach to optimize a statement block with…RULE The RULE hint disables the use of the query optimizer. This hint is unsupported and should not be used. rule_hint::= Text description of the illustration rule_hint.gif

Reference, 10g Release 1 (10.1)

A Oracle Text Result Tables

Operation Value Query Operator Equivalent SymbolABOUT (none) ACCUMULATE ACCUM, AND AND & COMPOSITE (none) (none) EQUIVALENCE EQUIV = MINUS MINUS - NEAR

Reference, 10g Release 1 (10.1)

A Oracle Text Result Tables

Operation Value Query Operator Equivalent SymbolABOUT ABOUT (none) ACCUMULATE ACCUM, AND AND & EQUIVALENCE EQUIV = MINUS MINUS - NEAR NEAR. NOT NOT

Developer's Guide, 10g Release 1 (10.1)

Viewing the Navigator Tree (Oracle Workflow Developer's Guide)

Viewing the Navigator Treeexpanded are preceded by a minus sign (-). You can expand no further when a branch displays neither … a plus nor minus sign. You can use either your mouse or the arrow keys on your keyboard to expand or

SQL Reference, 10g Release 1 (10.1)

9 SQL Queries and Subqueries

9 SQL Queries and SubqueriesQueries and Subqueries Creating Simple Queries Hierarchical Queries The UNION [ALL], INTERSECT, MINUS

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

45 DBMS_LOB

Return Valueand is calculated as (4 gigabytes minus 1) times the value of the DB_BLOCK_SIZE initialization parameter.

DML Reference, 10g Release 1 (10.1)

NASKIP2

NASKIP2) and - (minus) operators. The result is NA when any operand is NA unless NASKIP2 is set to YES. Data type BOOLEAN Syntax NASKIP2 = YES|NO Arguments

SQL Reference, 10g Release 1 (10.1)

Set Operators

Operator Returnsqueries MINUS All distinct rows selected by the first query but not the second

SQL Reference, 10g Release 1 (10.1)

Set Operators

Set Operatorsdescribed, including examples and restrictions on these operators, in "The UNION [ALL], INTERSECT, MINUS Operators".

DML Reference, 10g Release 1 (10.1)

PARENS

YESEncloses negative values in parentheses, instead of using a minus sign. NO Uses a minus sign to … specifies the use of parentheses; the NOPAREN attribute specifies the use of a minus sign. Allowing Space … use the minus sign, and you might need to increase your column width to accommodate your data

User's Guide and Reference, 10g Release 1 (10.1)

13 Geometry Subprograms

SDO_GEOM.SDO_DIFFERENCE     ) RETURN SDO_GEOMETRY; Description Returns a geometry object that is the topological difference (MINUS operation) of two geometry objects. Parameters


Was this page helpful?