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 40 of 786 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

COUNT *CUME_DIST

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

COUNTCOVAR_POP

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 26 of 177

COUNTSyntax count::= Text description of count See Also: "Analytic Functions" for information on syntax … , semantics, and restrictions Purpose COUNT returns the number of rows in the query. You can use it … you specify expr, then COUNT returns the number of rows where expr is not . You can count either

Objects for OLE, 9i Release 2 (9.2.0.2)

Count Property

Count PropertyFeedback Count Property See Also Example Applies To OraConnections Collection OraFields Collection … . Usage connection_count = oraconnections.Count field_count = orafields.Count parameter_count … = oraparameters.Count session_count = orasessions.Count subscriptions_count = OraSubscriptions.Count

Programmer's Guide, 9i Release 2 (9.2.0.2)

More OCI Relational Functions, 49 of 106

count (IN)The number of elements in the subscription handle array.

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

Windows NT Event Tests

Handle CountDescription Handle Count calculates the total number of handles currently open by each thread in

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Any Type and Data Functions, 24 of 26

count (OUT)Number of instances in OCIAnyDataSet. Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

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

Windows NT Event Tests

Thread CountDescription Thread Count measures the number of threads in the process that are currently active … process has at least one thread. If the Thread Count is greater than or equal to the threshold values

Programmer's Guide, 9i Release 2 (9.2.0.2)

More OCI Relational Functions, 50 of 106

count (IN)The number of elements in the subscription handle array.

Objects for OLE, 9i Release 2 (9.2.0.2)

Example: Count (OraObject) Property

Example: Count (OraObject) PropertyFeedback Example: Count (OraObject) Property The following example shows the usage of the Count property

Objects for OLE, 9i Release 2 (9.2.0.2)

Count (OraObject/OraRef) Property

Count (OraObject/OraRef) PropertyFeedback Count (OraObject/OraRef) Property Applies To OraObject Object OraRef Object Description Returns … -only at run time. Usage attrcount = OraRef. Count attrcount = OraObject. Count Remarks Individual … attribute index starts at 1. Data Type Integer Example Example: Count (OraObject) Property   Copyright

Objects for OLE, 9i Release 2 (9.2.0.2)

Count Property Example

Count Property ExampleFeedback Count Property Example This example demonstrates the use of the Count property to display the

Objects for OLE, 9i Release 2 (9.2.0.2)

Count (OraMetaData) Property

Count (OraMetaData) PropertyFeedback Count (OraMetaData) Property Applies To OraMetaData Object Description An integer representing … the number of OraMDAttributes contained in this collection. Usage count = OraMetaData. Count Remarks

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Object-Relational Programming

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

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

Querying

SQL Count Hits ExampleTo find the number of documents that contain the word oracle, issue the query with the SQL COUNT … function as follows: SELECT count(*) FROM news WHERE CONTAINS(text, 'oracle', 1) > 0;

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

Oracle Database Event Tests

AQ Expired Messages CountDescription This data item contains the number of messages for the current queue that are in the 'EXPIRED' state. This test checks the number of messages in the 'EXPIRED' state specified by the Queue Name(s) parameter. If the value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences"

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.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.

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

Oracle Database Event Tests

Suspended Session CountDescription This test checks the count of sesssions that are currently in the suspended state. If … the Suspended Count is greater than or equal to the threshold values specified by the threshold

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

Introduction to Oracle Text

Presenting Document Hit CountYou can present the number of hits the query returned alongside the hit list, using SELECT COUNT … (*). For example: SELECT COUNT(*) FROM docs WHERE CONTAINS(text, 'oracle', 1) > 0; To count hits in PL

Programmer's Guide, 9i Release 2 (9.2.0.2)

Using SQL Statements in OCI

Setting Prefetch CountIn order to minimize server round trips and maximize the performance of applications, the OCI can prefetch result set rows when executing a query. The OCI programmer can customize this prefetching by setting the OCI_ATTR_PREFETCH_ROWS or OCI_ATTR_PREFETCH_MEMORY attribute of the statement handle using the OCIAttrSet() function. The attributes are used as follows: OCI_ATTR_PREFETCH_ROWS sets the number

Objects for OLE, 9i Release 2 (9.2.0.2)

Record Count Example for OraSQLStmt

Record Count Example (OraSQLStmt)Feedback Record Count Example (OraSQLStmt) The following example shows the number of records inserted

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

Oracle Database Event Tests

AQ Ready Messages CountDescription This data item contains the number of messages for the current queue in the 'READY' state. This test checks the number of messages in the 'READY' state specified by the Queue Name(s) parameter. If the value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter,

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

Oracle Database Event Tests

AQ Waiting Messages CountDescription This data item contains the number of messages for the current queue in the 'WAITING' state. This test checks the number of messages in the 'WAITING' state specified by the Queue Name(s) parameter. If the value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter,

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

Oracle Database Event Tests

Wait by Session CountDescription This data item represents the number of sessions currently waiting on this event. This test checks the number of sessions currently waiting for the event specified by the Wait Event(s) parameter. If the value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter,

Developer's Guide, 9i Release 2 (9.2.0.2)

COM Automation Error Messages

COM-0015: Bad parameter countAction: Make sure the number of parameters for a method is equal to the count.

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

Querying

PL/SQL Count Hits Examplecount number; begin count:= ctx_query.count_hits(index_name => my_index, text_query => 'oracle … ', exact => TRUE); dbms_output.put_line('Number of docs with oracle:'); dbms_output.put_line(count); end

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Capacity Planner Messages

VTP-0041: Error getting data count: string .Cause: An error has occurred while attempting to determine the count of the data rows for the

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05448 Error: invalid UDS column countCause: An internal error has occurred while attempting to interpret a request for user-defined script columns. Action: contact Oracle Support Services.

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

SQLJ Error Messages

Missing count elements in INTO list: typesCause: The FETCH statement has fewer columns on the fetch cursor than required by the INTO bind variable list.

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

Relational Programming

Optimizing Performance by Setting Prefetch Countrow count and memory size to zero. Note: Prefetching is not in effect if LONG columns are part of

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05447 Error: negative UDS column countCause: An internal error has occurred while attempting to interpret a request for user-defined script columns. Action: contact Oracle Support Services.

Developer's Guide, 9i Release 2 (9.2.0.2)

COM Automation Error Messages

COM-0009: Failed to get type info countAction: Check that the object is properly registered.

Dynamic Services User's and Administrator's Guide, 9i Release 2 (9.2.0.2)

Error Messages

DS-155, DSE Execution failed with inconsistent Request Count: {0}Cause: Request count integrity is violated in an asynchronous DSDriver. Action: Contact Oracle Customer Support Services.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Counting the Elements in a Collection (COUNT Method)COUNT returns the number of elements that a collection currently contains. For instance, if varray … ... COUNT is useful because the current size of a collection is not always known. For example, if you … fetch a column of Oracle data into a nested table, how many elements does the table contain? COUNT … gives you the answer.

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

SQLJ Error Messages

Cannot analyze SQL statement online: unable to determine SQL types for count host items.Cause: SQLJ determines a corresponding SQL type for each of the Java host expressions. These SQL types are required for checking the statement online. Action: Use Java types that are supported by Oracle SQLJ.

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

SQLJ Error Messages

Cursor has item count items. Argument #pos of INTO-list is invalid.Cause: Your INTO-list has more elements than the corresponding positional iterator from which you are fetching. Action: Remove the extra INTO-list elements.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-24333 zero iteration countCause: An iteration count of zero was specified for the statement. Action: Specify the number of times this statement must be executed.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-16537 child count exceededCause: This is an internal error. Action: Contact Oracle Support Services.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-04100 to ORA-07499

ORA-06533 Subscript beyond countCause: An in-limit subscript was greater than the count of a VARRAY or too large for a nested table

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-16523 property count exhaustedCause: Total number of resource properties exceeded the limit.