Results for COUNT


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


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 … . If you specify expr, then COUNT returns the number of rows where expr is not . You can count

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, 2 of 177

COUNT *CUME_DIST

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, 50 of 106

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

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

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)

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

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 (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

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

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 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\"

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

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\"

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,

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

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

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.

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

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

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.

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

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.

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.

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.

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.

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.

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.

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-12700 to ORA-19399

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

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-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)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02143 SUM(expr) without COUNT(expr)Cause: SUM(expr) occurs in the select list without a corresponding COUNT(expr). Action: Add COUNT(expr) to the select list.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-00973 invalid row count estimateORA-00974 invalid PCTFREE value (percentage) Cause: The percentage of free space specified in a CREATE INDEX statement is not between 0 and 100. A PCTFREE value of 0 means the entire block is available. The value 100 is not useful because it means that no data may be inserted. The default is 10. Action: Specify a PCTFREE value between 0 and 100. Then retry the statement.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-13112 invalid count mode stringCause: The specified count mode is not valid. Action: Alter the count mode. Valid count modes are ESTIMATE or EXACT.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Net Messages (TNS)

TNS-02504 Parameter count retrieval failedCause: The native service layer was unable to determine the number of arguments given for a configuration parameter. Action: If it is possible, enable tracing and attempt to reproduce the problem. In any event, contact Oracle Support Services.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30454 summary contains STDDEV without corresponding SUM & COUNTCause: Incremental refresh of summaries with STDDEV(X) requires COUNT(X) and SUM(X) columns to be

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00000 to ORA-00899

ORA-00333 redo log read error block string count stringCause: An I/O error occurred while reading the log described in the accompanying error. Action: Restore accessibility to file, or get another copy of the file.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14309 Total count of list values exceeds maximum allowedCause: Partitioned object contains more than 65535 list values. Action: Reduce number of values to less than 65535.

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02142 COUNT(*) is not present in the select listCause: The materialized view query omits COUNT(*) from the select list. Action: Add COUNT(*) to the select list.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00000 to ORA-00899

ORA-00345 redo log write error block string count stringCause: An I/O error occurred while writing the log. Action: Correct the cause of the error, and then restart the system. If the log is lost, apply media/incomplete recovery.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30453 summary contains AVG without corresponding COUNTCause: Incremental refresh of summaries with AVG(X) requires a COUNT(X) column to be included in

Error Messages, 9i Release 2 (9.2.0.2)

Recovery Manager Messages (RMAN)

RMAN-06148 redundancy count must be greater than zeroCause: The REDUNDANCY operand specified for a CHANGE or REPORT OBSOLETE command was zero. Action: Specify a REDUNDANCY operand value greater than or equal to 1.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-04100 to ORA-07499

ORA-06044 NETDNT: connect failed, byte count quota exceededCause: Connect failed because of insufficient byte count quota. Action: Increase byte count quota.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Net Messages (TNS)

TNS-03502 Insufficient arguments. Usage: tnsping address [ count ]Cause: Some required command-line arguments are missing. Action: Re-enter the command using the correct arguments.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-24362 improper use of the character count flagCause: When the character count flag is set, then the maximum size of the buffer in the server

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02132 agg(expr) requires corresponding COUNT(expr) functionaggregate functions but omits an invocation of the COUNT function on the same argument. Action: Add the COUNT function to the select list.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30455 summary contains VARIANCE without corresponding SUM & COUNTCause: Incremental refresh of summaries with VARIANCE(X) requires COUNT(X) and SUM(X) columns to be

Error Messages, 9i Release 2 (9.2.0.2)

ORA-09858 to ORA-12299

ORA-10587 Invalid count for ALLOW n CORRUPTION optionCause: The number specified in the ALLOW n CORRUPTION option is too big. Action: Use a smaller number.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-29253 Invalid count argument passed to procedure dbms_sql.define_arrayCause: The count argument specified in the call to procedure DEFINE_ARRAY of package DBMS_SQL had

Error Messages, 9i Release 2 (9.2.0.2)

SQL Runtime Messages (SQL)

SQL-02148 ANSI Dynamic count value out of rangeCause: The count in a dynamic GET or SET statement is less than one or greater than MAX given for … descriptor allocation. Action: Supply a number for the COUNT clause between 1 and the MAX occurrences supplied when the descriptor was allocated.

Error Messages, 9i Release 2 (9.2.0.2)

Recovery Manager Messages (RMAN)

RMAN-06532 redundancy count must be greater than zeroCause: The REDUNDANCY operand specified for the retention policy was zero. Action: Specify a REDUNDANCY operand of 1 or greater.





Was this page helpful?

Integrated Cloud Applications & Platform Services