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 ROWNUM


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


SQL Reference, 9i Release 2 (9.2.0.2)

Basic Elements of Oracle SQL, 6 of 10

ROWNUMFor each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in … which Oracle selects the row from a table or set of joined rows. The first row selected has a ROWNUM … of 1, the second has 2, and so on. You can use ROWNUM to limit the number of rows returned by a … query, as in this example:

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

More OCI Relational Functions, 53 of 106

rownum (IN)Zero-based row offset

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

More OCI Relational Functions, 55 of 106

rownum (IN)Zero-based row offset

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

More OCI Relational Functions, 54 of 106

rownum (IN)Zero-based row offset

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

ROWIDROWNUM

Error Messages, 9i Release 2 (9.2.0.2)

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

QSM-02057 ROWNUM referenced in materialized viewCause: The capability in question is not supported when the materialized view references the ROWNUM … function. Action: Re-phrase the query to avoid the use of the ROWNUM function.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-00976 LEVEL, PRIOR, or ROWNUM not allowed hereCause: The use of the PRIOR clause, the pseudo-column LEVEL, or ROWNUM is incorrect in this context … . Action: Check the syntax for the SQL statement. Then remove or relocate the keyword PRIOR, LEVEL, or ROWNUM.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-02100 to ORA-04099

ORA-02471 SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expression.Cause: SYSDATE, UID, USER, ROWNUM, or LEVEL are not allowed in hash expressions. Action: Re-create the cluster and remove the offending keywords.

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

More OCI Relational Functions, 53 of 106

Syntaxsword OCIDirPathColArrayEntryGet ( OCIDirPathColArray *dpca, OCIError *errhp, ub4 rownum, ub2 colIdx, ub1 **cvalpp, ub4 *clenp, ub1 *cflgp );

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

More OCI Relational Functions, 55 of 106

Syntaxsword OCIDirPathColArrayRowGet ( OCIDirPathColArray *dpca, OCIError *errhp, ub4 rownum, ub1 ***cvalppp, ub4 **clenpp, ub1 **cflgpp );

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

More OCI Relational Functions, 54 of 106

Syntaxsword OCIDirPathColArrayEntrySet ( OCIDirPathColArray *dpca, OCIError *errhp, ub4 rownum, ub2 colIdx, ub1 *cvalp, ub4 clen, ub1 cflg );

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

Interaction Between PL/SQL and Oracle

SQL Pseudocolumns, NEXTVAL, ROWID, and ROWNUM. Pseudocolumns are not actual columns in a table but they behave like … identify the latest row fetched from a cursor. For an example, see "Fetching Across Commits". ROWNUMROWNUM returns a number indicating the order in which a row was selected from a table. The first row … selected has a ROWNUM

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

Internal Persistent LOBs

C/C++ (ProC/C++): Inserting a Row by Initializing a LOB Locator Bind Variable); } void insertUseBindVariable_proc(Rownum, Lob_loc) int Rownum, Rownum2; OCIBlobLocator *Lob_loc; { EXEC … , ad_photo) VALUES (:Rownum,:Rownum2,:Lob_loc); } void insertBLOB_proc() { OCIBlobLocator *Lob_loc

SQL Reference, 9i Release 2 (9.2.0.2)

Basic Elements of Oracle SQL, 6 of 10

Pseudocolumnsthese pseudocolumns: CURRVAL and NEXTVAL LEVEL ROWID ROWNUM XMLDATA

Objects for OLE, 9i Release 2 (9.2.0.2)

RowPosition Property

RowPosition Propertycurrent row in the dynaset. Not available in design time and read only in runtime. Usage rownum

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

Performance Tuning

Improved Response Time with Local Partitioned Index for Order by Scorethe FIRST_ROWS or DOMAIN_INDEX_SORT hint. The query on the in-line view has ROWNUM predicate limiting … where contains(doc, 'oracle', 1)>0 order by score(1) desc) where rownum See Also: Oracle9i Database

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

Spatial Operators

unit If the SDO_NN_DISTANCE ancillary operator is included in the call to SDO_NN, specifies the unit…) to be returned. If sdo_batch_size is specified, this keyword is ignored; instead, use the ROWNUM … WHERE clause, use the sdo_batch_size keyword and use the WHERE clause (including the ROWNUM … = 'Italian' AND ROWNUM If the sdo_batch_size keyword is not specified in this example, only the two … two rows is not Italian, the query

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes and Host Variables

External Datatypes… A reference to NEXTVAL stores the current sequence number in CURRVAL. ROWNUM returns a number … indicating the sequence in which a row was selected from a table. The first row selected has a ROWNUM of … 1, the second row has a ROWNUM of 2, and so on. If a SELECT statement includes an ORDER BY clause … , ROWNUMs are assigned

SQL Reference, 9i Release 2 (9.2.0.2)

Expressions, 3 of 14

Simple Expressionspseudocolumn can be either LEVEL, ROWID, or ROWNUM. You can use a pseudocolumn only with a table, not

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

Maintaining Data Integrity Through Constraints

Restrictions on CHECK ConstraintsSQL functions. The condition cannot contain the pseudocolumns LEVEL, PRIOR, or ROWNUM. See Also