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 COUNT


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


Database SQL Language Reference, 11g Release 2 (11.2)

COUNT

COUNTinformation on syntax, semantics, and restrictions Purpose COUNT returns the number of rows returned by the … windowing_clause are not allowed. If you specify expr, then COUNT returns the number of rows where expr is not … . You can count either all rows, or only distinct values of expr. If you specify the asterisk … (*), then

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Collections and Records

COUNT Collection MethodCOUNT is a function that returns the number of elements in the collection (ignoring deleted … elements, even if DELETE kept placeholders for them). Topics COUNT Method for Varray COUNT Method for … Nested Table COUNT Method for Varray For a varray, COUNT always equals LAST. If you increase or decrease

OLAP DML Reference, 11g Release 2 (11.2)

COUNT

boolean-expression-expression and another dimension that you want as a dimension of the result. By default, COUNT … returns a single YES or NO value. When you indicate one or more dimensions for the result, COUNT tests for … specify relation. Usage Notes The Effect of NASKIP on COUNT COUNT is affected by the NASKIP option … . When

OLAP Expression Syntax Reference, 11g Release 2 (11.2)

COUNT

COUNTuseful for calculations on fiscal and nonstandard hierarchies. Return Value NUMBER Syntax COUNT … time period. The selected data displays the number of each month in the year. COUNT … ANCESTOR AT DIMENSION LEVEL GLOBAL.TIME.CALENDAR_YEAR) TIME UNITS COUNT JAN-06 47776 1 FEB-06 47695

OLAP DML Reference, 11g Release 2 (11.2)

COUNT

COUNTThe COUNT function counts the number of TRUE values of a Boolean expression. It returns 0 (zero … ) when no values of the expression are TRUE. Return Value INTEGER Syntax COUNT( boolean-expression  [CACHE] [ dimension...]) Parameters

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

OracleParameterCollection Class

Count// ADO.NET 2.0: C# public override int Count {get;} Property Value The number of OracleParameter objects

Objects for OLE Developer's Guide for Microsoft Windows, 11g Release 2 (11.2)

Count Property

Count Propertythe use of the Count property to display the number of objects in the OraSessions, OraConnections, and

Objects for OLE Developer's Guide for Microsoft Windows, 11g Release 2 (11.2)

Count (OraObject/Ref) Property

Count (OraObject/Ref) Propertyat 1. Examples The following example shows the use of the Count property. Before running the sample

Objects for OLE Developer's Guide for Microsoft Windows, 11g Release 2 (11.2)

Count (OraMetaData) Property

Count (OraMetaData) Propertyobjects contained in this collection. Usage count = OraMetaData.Count Data Type Integer See Also: OraMDAttribute Object

Oracle Call Interface Programmer's Guide, 11g Release 2 (11.2)

Using SQL Statements in OCI

Setting Prefetch CountTo minimize server round-trips and optimize performance, OCI can prefetch result set rows when executing a query. You can customize this prefetching by setting either the OCI_ATTR_PREFETCH_ROWS or OCI_ATTR_PREFETCH_MEMORY attribute of the statement handle using the OCIAttrSet() function. These attributes are used as follows: OCI_ATTR_PREFETCH_ROWS sets the number of rows to be prefetched. If it is

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 2 (11.2)

Error Handling and Diagnostics

Rows-Processed CountThe number of rows processed by the most recently executed SQL statement is recorded in the SQLCA variable SQLERD(3). For repeated FETCHes on an OPEN cursor, SQLERD(3) keeps a running total of the number of rows fetched.

Application Express Application Builder User's Guide, 11g Release 2 (11.2)

Using Collections

Obtaining a Member CountUse COLLECTION_MEMBER_COUNT to return the total count of all members in a collection. Note that … this count does not indicate the highest sequence in the collection, for example: l_count:= APEX_COLLECTION.COLLECTION_MEMBER_COUNT ( p_collection_name => collection name );

Oracle Call Interface Programmer's Guide, 11g Release 2 (11.2)

OCI Object-Relational Programming

Pin Count and UnpinningEach object in the object cache has a pin count associated with it. The pin count indicates the … number of code modules that are concurrently accessing the object. The pin count is set to 1 when an … enter the object cache with a pin count of zero. It is possible to pin an pinned object. Doing so … increases

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

Handling Runtime Errors

Rows-Processed CountThe number of rows processed by the most recently executed SQL statement is returned in the SQLCA variable sqlca.sqlerrd[2], which you can check explicitly. Strictly speaking, this variable is not for error reporting, but it can help you avoid mistakes. For example, suppose you expect to delete about ten rows from a table. After the deletion, you check sqlca.sqlerrd[2] and find that 75 rows were processed.

TimesTen In-Memory Database SQL Reference, 11g Release 2 (11.2)

Functions

COUNTof the result is TT_INTEGER. COUNT is an aggregate function and can also be an aggregate analytic … System Tables and Views Reference. SQL syntax COUNT ({* | [ALL | DISTINCT]{Expression|ROWID}}) [OVER … ([AnalyticClause])] Parameters COUNT has the parameters: Parameter Description Expression Can be any … rows that satisfy the

Universal Connection Pool for JDBC Developer's Guide, 11g Release 2 (11.2)

Optimizing Universal Connection Pool Behavior

Setting the Harvest Maximum CountThe connection harvest maximum count property specifies how many borrowed connections should be … returned to the pool once the harvest trigger count has been reached. The number of connections … actually harvested may be anywhere from 0 to the connection harvest maximum count value. Least recently … the most. The harvest maximum

COM Automation Feature Developer's Guide for Microsoft Windows, 11g Release 2 (11.2)

COM Automation Error Messages

COM-0015: Bad parameter countCause: There was an error invoking the method or property. Action: Verify that the method name is valid for the object. COM-0015: Bad parameter count

Universal Connection Pool for JDBC Developer's Guide, 11g Release 2 (11.2)

Optimizing Universal Connection Pool Behavior

Setting the Harvest Trigger CountThe connection harvest trigger count specifies the available connection threshold that triggers … connection harvesting. For example, if the connection harvest trigger count is set to 10, then … harvesting by configuring a connection harvest trigger count. pds.setConnectionHarvestTriggerCount(2);

Application Express Administration Guide, 11g Release 2 (11.2)

Managing Log Files

Purging the External Click Count LogThe external Click Count Log counts clicks from an application to an external site. You can … Oracle Application Express API Reference To purge the external Click Count Log: Navigate to the … . Under Logs, click Manage Click Count Log. Click Purge Click Log. See Also: \"Monitoring Activity within a Workspace\"

Oracle C++ Call Interface Programmer's Guide, 11g Release 2 (11.2)

Relational Programming

Optimizing Performance by Setting Prefetch CountOptimiz ing Performance by Setting Prefetch Count Although the ResultSet method retrieves data one … database fetches an extra row all the time. To turn prefetching off, set both the prefetch row count and

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Oracle ACFS Command-Line Utilities for Multiple Environments

acfsutil info fsfs -h acfsutil info fs [ { -o item | -s [ interval [ count ] ] } ] [ mount_point ] acfsutil info fs

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Oracle ACFS Command-Line Utilities for Multiple Environments

Option Description Syntaxquit read Reads value from offset The default size to read in is 8 bytes The default count to read is … 1 read [ -1 | -2 | -4 | -8 | -s ] [ count ] offset -1 Read byte value -2 Read 2 byte (short) value … -4 Read 4 byte (int) value -8 Read 8 byte (long) value -s Read - terminated string count Number

Database SQL Language Reference, 11g Release 2 (11.2)

STATS_MODE

STATS_MODEhypothetical query: SELECT x FROM (SELECT x, COUNT(x) AS cnt1 FROM t GROUP BY x) WHERE cnt1 = (SELECT MAX(cnt2 … ) FROM (SELECT COUNT(x) AS cnt2 FROM t GROUP BY x)); Examples The following example returns the mode … : SELECT commission_pct FROM (SELECT commission_pct, COUNT(commission_pct) AS cnt1 FROM employees GROUP BY … commission_pct)

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

NO_XMLINDEX_REWRITE Hint/*+NO_XMLINDEX_REWRITE*/ count(*) FROM warehouses WHERE existsNode(warehouse_spec, '/Warehouse/Building

Database Programmer's Guide to the Oracle Precompilers, 11g Release 2 (11.2)

Error Handling and Diagnostics

Rows-Processed CountThe number of rows processed by the most recently executed SQL statement is returned in the SQLCA variable SQLERRD(3), which you can check explicitly. Speaking strictly, this variable is not for error reporting, but it can help you avoid mistakes. For example, suppose you expect to delete about ten rows from a table. After the deletion, you check SQLERRD(3) and find that 75 rows were processed. To

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Oracle ACFS Command-Line Utilities for Multiple Environments

Option Description-s [ interval [ count ]] Displays file system statistics. The optional interval parameter specifies … interval since the previous report. The optional count parameter can be specified in conjunction with the … interval parameter. If the count parameter is specified, the value of count determines the number … count

Database Performance Tuning Guide, 11g Release 2 (11.2)

Configuring and Using Memory

Table 7-6 Views and Tables Related to the Server and Client Result CachesVALUE -------------------- ---------- Block Size (Bytes) 1024 Block Count Maximum 3136 Block Count … Current 32 Result Size Maximum (Blocks) 156 Create Count Success 2 Create Count Failure 0 Find Count 0 … Invalidation Count 0 Delete Count Invalid 0 Delete Count

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Performing Oracle ASM Data Migration with RMAN

Basic Concepts of Oracle ASM Data Migrationold recovery area and count against the total disk quota of the recovery area. The backups are deleted

Database Administrator's Guide, 11g Release 2 (11.2)

Oracle Scheduler Concepts

After Jobs Completeentry into the job log table. Update the run count, and if necessary, failure and retry counts. Clean

Database SQL Language Reference, 11g Release 2 (11.2)

CORR_*

CORR_Sand commission_pct, and salary and employee_id: SELECT COUNT(*) count, CORR_S(salary, commission_pct … ) commission, CORR_S(salary, employee_id) empid FROM employees; COUNT COMMISSION EMPID ---------- ---------- ---------- 107.735837022 -.04473016

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Optimization and Tuning

BULK COLLECT Clausestatement'); DBMS_OUTPUT.PUT_LINE('numbers1.COUNT() = ' || numbers1.COUNT()); FOR j IN 1..numbers1.COUNT … '); DBMS_OUTPUT.PUT_LINE('numbers1.COUNT() = ' || numbers1.COUNT()); END p; / Invoke p: BEGIN p(2); END … ; / Result: Before SELECT statement numbers1.COUNT() = 5 numbers1(1) =

Database SQL Language Reference, 11g Release 2 (11.2)

LNNVL

LNNVLa commission of less than 20%: SELECT COUNT(*) FROM employees WHERE commission_pct To include the … as follows: SELECT COUNT(*) FROM employees WHERE LNNVL(commission_pct >=.2); COUNT(*) ---------- 83

Database Administrator's Guide, 11g Release 2 (11.2)

Repairing Corrupted Data

Example: Finding Index Entries Pointing to Corrupt Data Blocks); DBMS_OUTPUT.PUT_LINE('orphan key count: ' || TO_CHAR(num_orphans)); END; / The following output indicates that … there are three orphan keys: orphan key count: 3 Index entries in the orphan key table implies that

Database SQL Language Reference, 11g Release 2 (11.2)

FEATURE_ID

FEATURE_IDfunctions Examples The following example lists the features and corresponding count of customers in a … . SELECT FEATURE_ID(nmf_sh_sample USING *) AS feat, COUNT(*) AS cnt FROM nmf_sh_sample_apply_prepared

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Views for Information About Triggersn INTEGER; BEGIN SELECT COUNT(*) INTO n FROM employees; DBMS_OUTPUT.PUT_LINE('There are now ' || n … -------------------------------------------------- DECLARE n INTEGER; BEGIN SELECT COUNT(*) INTO n FROM

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

INSTEAD OF DML Triggers'); END order_info_insert; / Query to show that row to be inserted does not exist: SELECT COUNT(*) FROM … order_info WHERE customer_id = 999; Result: COUNT(*) ---------- 0 1 row selected. Insert row into … created. Query to show that row has been inserted in view: SELECT COUNT(*) FROM order_info WHERE … customer_id = 999; Result:

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Collections and Records

LIMIT Collection Method… Example 5-28 and prints the values of LIMIT and COUNT for an associative array with four elements … , a varray with two elements, and a nested table with three elements. Example 5-28 LIMIT and COUNT

Database SQL Language Reference, 11g Release 2 (11.2)

VAR_SAMP

VAR_SAMP… The function makes the following calculation: (SUM(expr - (SUM(expr) / COUNT(expr)))2) / (COUNT

Database SQL Language Reference, 11g Release 2 (11.2)

NUMTODSINTERVAL

NUMTODSINTERVALon implicit conversion Examples The following example uses NUMTODSINTERVAL in a COUNT analytic … syntax of the analytic functions. SELECT manager_id, last_name, hire_date, COUNT(*) OVER (PARTITION

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Collection Method Invocation

Collection Method Invocationcollection whose method you are invoking. COUNT Function that returns the number of elements in the … collection, explained in \"COUNT Collection Method\". DELETE Procedure that deletes elements from the … , \"Printing Nested Table with FIRST and LAST in FOR LOOP\" Example 5-26, \"COUNT and LAST Values for … Varray\" Example 5-27,

Database Gateway for DRDA User's Guide, 11g Release 2 (11.2)

Developing Applications

4.7.9 Mapping the COUNT FunctionOracle database supports the following four operands for the COUNT function: COUNT(*) COUNT … (DISTINCT colname) COUNT(ALL colname) COUNT(colname) Some DRDA servers do not support all forms of COUNT … , specifically COUNT(colname) and COUNT(ALL colname).

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Implicit Cursor Attribute

Implicit Cursor Attributemost recently run FORALL statement. SQL%BULK_EXCEPTIONS. COUNT is the number of DML statements that … failed. If SQL%BULK_EXCEPTIONS. COUNT is not zero, then for each index value i from 1 through SQL … %BULK_EXCEPTIONS. COUNT: SQL%BULK_EXCEPTIONS( i ). ERROR_INDEX is the number of the DML statement

Database SQL Language Reference, 11g Release 2 (11.2)

Floating-Point Conditions

Table 7-3 Floating-Point Conditions… SELECT COUNT(*) FROM employees WHERE commission_pct IS NOT NAN; IS [NOT] INFINITE Returns TRUE if expr

Database SQL Language Reference, 11g Release 2 (11.2)

Aggregate Functions

Aggregate Functionsexcept COUNT (*), GROUPING, and GROUPING_ID ignore s. You can use the NVL function in the … argument to an aggregate function to substitute a value for a . COUNT and REGR_COUNT never return … function returns . The aggregate functions MIN, MAX, SUM, AVG, COUNT, VARIANCE, and STDDEV, when … windowing_clause. AVG COLLECT CORR CORR_*

Database SQL Language Reference, 11g Release 2 (11.2)

VAR_POP

VAR_POP… The function makes the following calculation: SUM((expr - (SUM(expr) / COUNT(expr)))2) / COUNT

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

To create an unusable index: created. hr@PROD> SELECT COUNT(*) FROM employees_part; COUNT(*) ---------- 107 Create an index with

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Collections and Records

Collection Methodscollection. LAST Function Returns last index in collection. COUNT Function Returns number of elements in … Collection Methods COUNT Collection Method LIMIT Collection Method PRIOR and NEXT Collection Methods

Database SQL Language Reference, 11g Release 2 (11.2)

REGR_ (Linear Regression) Functions

REGR_ (Linear Regression) Functions-hire_date, salary) OVER (PARTITION BY job_id) count, REGR_AVGX(SYSDATE-hire_date, salary) OVER … COUNT AVGX AVGY ---------- ----- ---------- ----- --------- ----- ------ ---------- --------- SA_MAN … Examples The following example calculates the count of by job_id for time employed ( SYSDATE … , REGR_COUNT(SYSDATE-hire_date,

Database Administrator's Guide, 11g Release 2 (11.2)

Developing Applications for a Distributed Database System

Analyzing the Execution Plandeptno FROM emp@orc2.world GROUP BY deptno HAVING COUNT (deptno) >3 ) / Viewing the Execution Plan … \".\"DEPTNO\" FROM \"EMP\" \"A1\" GROUP BY \"A1\".\"DEPTNO\" HAVING COUNT(\"A1\".\"DEPTNO\")>3 Note

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Example 3: Displaying Statistics for Free Space (Extents) of Each Tablespacedatabase, enter the following query: SELECT TABLESPACE_NAME \"TABLESPACE\", FILE_ID, COUNT(*) \"PIECES

Database SQL Language Reference, 11g Release 2 (11.2)

Literals

NUMBER and Floating-Point LiteralsBINARY_FLOAT for which the condition IS NAN is true SELECT COUNT(*) FROM employees WHERE … SELECT COUNT(*) FROM employees WHERE salary binary_double_nan A value of type BINARY_DOUBLE for which … the condition IS NAN is true SELECT COUNT(*) FROM employees WHERE TO_BINARY_FLOAT(commission_pct … ) != BINARY_FLOAT_NAN; binary_double_infinity

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Mutating-Table Restriction); SELECT COUNT(*) INTO n FROM employees; DBMS_OUTPUT.PUT_LINE('There are now ' || n || ' employees … count(*) FROM log; Result: COUNT(*) ---------- 0 1 row selected. Show that effect of triggering … , and maintaining a count of children can all be implemented easily—see \"Triggers for Ensuring

Database SQL Language Reference, 11g Release 2 (11.2)

CLUSTER_ID

CLUSTER_ID… SELECT CLUSTER_ID(km_sh_clus_sample USING *) AS clus, COUNT(*) AS cnt FROM mining_data_apply_v GROUP

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Language Fundamentals

SQL Functions in PL/SQL ExpressionsCOUNT ) Analytic functions (such as LAG and RATIO_TO_REPORT ) Data mining functions (such as

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

DYNAMIC_SAMPLING Hintany dynamic sampling if employees is analyzed: SELECT /*+ DYNAMIC_SAMPLING(e 1) */ count(*) FROM

Database SQL Language Reference, 11g Release 2 (11.2)

CREATE SYNONYM

CREATE SYNONYMissues the following statement, then the database returns the count of rows from sh.customers … : SELECT COUNT(*) FROM customers; To retrieve the count of rows from oe.customers, the user sh must preface … .) SELECT COUNT(*) FROM oe.customers; If the user hr 's schema does not contain an object named … schema

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBALTER TIME_DIMENSION

yearCountYear count in INTEGER_LITERAL

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Dropping Table ColumnsCOUNT field shows the number of unused columns in the table. SELECT * FROM DBA_UNUSED_COL_TABS; OWNER … TABLE_NAME COUNT --------------------------- --------------------------- ----- HR ADMIN_EMP 2 For

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Diagnostic Data

Table 9-3 Data in the V$DIAG_INFO View/orcl_ora_22769.trc 1 Active Problem Count 8 1 Active Incident Count 20 The following table describes

Database SQL Language Reference, 11g Release 2 (11.2)

REGEXP_COUNT

REGEXP_COUNTREGEXP_COUNT('123123123123', '123', 3, 'i') COUNT FROM DUAL; COUNT ---------- 3