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 LAST


1 to 60 of 1545 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

LASTMAX MIN

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 57 of 177

LASTSyntax last::= Text description of last See Also: "Analytic Functions" for information on syntax … , semantics, and restrictions of the query_partitioning_clause Purpose FIRST and LAST are very similar … rows that rank as the FIRST or LAST with respect to a given sorting specification. If only one row … ranks

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

Events

Last UpdatedTime of last update

Objects for OLE, 9i Release 2 (9.2.0.2)

Moving to First and Last Rows

Moving to First and Last RowsFeedback Moving to First and Last Rows See Also Quick Tour Employee Form To move to the first row of a … cmdFirst_Click() EmpDynaset.MoveFirst Call EmpRefresh End Sub To move to the last row, we use the … employee example, the Last click event procedure looks like: Private Sub cmdLast_Click

Objects for OLE, 9i Release 2 (9.2.0.2)

FindFirst, Find Last, FindNext, FindPrevious Methods

FindFirst, Find Last, FindNext, FindPrevious MethodsMaster Index Feedback FindFirst, Find Last, FindNext, FindPrevious Methods Applies To ODynaset … successfully. If clause matches the last clause from the previous Find, the WHERE clause is not re-parsed

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

New and Changed Features

"Ignore Last Error" Optionlets you ignore the last error from the previous call to the procedure. Information about the last

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Aggregating Data, 5 of 12

Hierarchical Last ( HLAST )And ( AND )

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

FIRST/LAST SyntaxThese functions have the following syntax: aggregate_function KEEP ( DENSE_RANK LAST ORDER BY expr … [ DESC | ASC ] [NULLS { FIRST | LAST }] [, expr [ DESC | ASC ] [NULLS { FIRST | LAST }]]... ) [OVER

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

FIRST/LAST FunctionsThe FIRST/LAST aggregate functions allow you to return the result of an aggregate applied over a … set of rows that rank as the first or last with respect to a given order specification. FIRST/LAST … rows (1 or more rows) that rank as first or last respect to the order specification to return a … single value.

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

FIRST/LAST As Regular AggregatesYou can use the FIRST / LAST family of aggregates as regular aggregate functions. Example 19-11 … FIRST/LAST Example 1 The following query lets us compare minimum price and list price of our products … (prod_list_price) KEEP (DENSE_RANK LAST ORDER BY (prod_min_price)) AS LP_OF_HI_MINP, MAX(prod_min_price

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

FIRST/LAST As Reporting AggregatesYou can also use the FIRST / LAST family of aggregates as reporting aggregate functions. An example … the example in Example 19-11 for FIRST/LAST. What if we wanted to find the list prices of individual … - Men subcategory by using FIRST/LAST as reporting aggregates. Because there are over 100 products … in this subcategory, we

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

PL/SQL Collections and Records

Finding the First or Last Collection Element (FIRST and LAST Methods)FIRST and LAST return the first and last (smallest and largest) index numbers in a collection. For … specified by the NLS_SORT initialization parameter. If the collection is empty, FIRST and LAST return … NULL. If the collection contains only one element, FIRST and LAST return the same index value: IF … FIRST

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Capacity Planner Messages

VTP-0149: Warning: The collection settings for this target were last modified by a different user.Cause: The repository where the historical data will be stored was last set by another Capacity

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

SQLJ Error Messages

Expected cursor host variable or NEXT, or PRIOR, or FIRST, or LAST, or ABSOLUTE, or RELATIVE.Cause: A host variable representing an iterator type or a keyword was expected here.

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

LAGLAST

Messages Manual, 9i Release 2 (9.2.0.2)

Console Messages

VTCX-1350: An irrecoverable error has occurred while accessing the last item. It is recommended that…Cause: The selection of tasks/tests on the job/event parameters page has changed, but there is no current selection. Action: Close the dialog and re-attempt the operation. If the problem persists, report the problem to Oracle Support Services.

interMedia Annotator User's Guide, 9i Release 2 (9.2.0.2)

Defined Annotation Attributes

MEDIA_MODIFICATION_TIME java.util.Date The time of the last modification of the media for example, Mon…time of the last modification of the media (for example, Mon Dec 13 19:29:04 EST 2001)

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

Spatial Operators

number Specifies a number that must be the same as the last parameter passed to the SDO_NN operator.…parameter. The only requirement is that it must match the last parameter in the call to the SDO_NN operator … SDO_NN_DISTANCE, and 1 is also specified as the last parameter to SDO_NN (after 'sdo_num_res=2' ). The column

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Aggregating Data, 5 of 12

Hierarchical First ( HFIRST )Last ( LAST )

Error Messages, 9i Release 2 (9.2.0.2)

Recovery Manager Messages (RMAN)

RMAN-20037 invalid last recidCause: This is an internal error. Action: Contact Oracle Support Services.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Names Control Utility Messages (NNL)

NNL-00416 Last timestamp: numberCause: Control program general message. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

Remote Operation Messages (NCR)

NCR-04016 NCRR: Last interface instance handleCause: The instance handle passed in is the last instance handle in the list. This is an

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-50914 invalid last document number stringCause: Invalid last document number. Action: Correct the query.

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

1003 or 2003 1 Simple polygon whose vertices are connected by straight line segments. Note that you…

1003 or 2003 1 Simple polygon whose vertices are connected by straight line segments. Note that you…line segments. Note that you must specify a point for each vertex, and the last point specified must

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14618 cannot drop the last value of subpartitionCause: ALTER TABLE DROP VALUES tried to drop the last value of the subpartition. Action: Cannot

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00000 to ORA-00899

ORA-00342 archived log was created before last RESETLOGSCause: Recovery was given a log that was created before the last ALTER DATABASE OPEN RESETLOGS

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01181 file string created before last RESETLOGS, cannot recreateexisted at the last RESETLOGS database open. Action: Find a backup of the file, and recover it. Do

Error Messages, 9i Release 2 (9.2.0.2)

External Naming Messages (NNF)

NNF-00502 Display the information retrieved by the last queryCause: Test program help text. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-26089 LONG column ' string ' must be specified lastwas not the last column to be specified. Action: Specify the LONG column last.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01479 last character in the buffer is not NullCause: A bind variable of type 97 does not contain at the last position. Action: Make the last character .

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14624 DEFAULT subpartition must be last subpartition specified: Ensure that the DEFAULT subpartition is the last subpartition description.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01209 data file is from before the last RESETLOGSclosed or the file is offline, the backup is old because it was taken before the last ALTER DATABASE

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-50915 last document number string is not an integerCause: Invalid last document number. Action: Correct the query.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-50916 last document string is less than first documentCause: Invalid last document number. Action: Correct the query.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14318 DEFAULT partition must be last partition specifiedthat the DEFAULT partition is the last partition description.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14317 cannot drop the last value of partitionCause: ALTER TABLE DROP VALUES tried to drop the last value of the partition. Action: Cannot

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

4 n > 1 Compound line string with some vertices connected by straight line segments and some by circular…

4 n > 1 Compound line string with some vertices connected by straight line segments and some by circular…subelements. The subelements can only be of SDO_ETYPE 2. The last point of a subelement is the first

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

OCI Programming Advanced Topics

fo_event The last parameter is the failover event. This indicates to the callback why it is being called.…OCI_FO_REAUTH indicates that a user handle has been reauthenticated. To find out which, the application should check the OCI_ATTR_SESSION attribute of the service context handle (which is the first parameter).

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

Handle and Descriptor Attributes

OCI_ATTR_COL_COUNTMode READ Description Last column of the last row processed.

Error Messages, 9i Release 2 (9.2.0.2)

SQL*Loader Messages (SQL*Loader)

SQL*Loader-00458 Comparison text (' string ') of CONTINUEIF LAST must be non-whitespaceCause: The comparison text is a white space character (blank or tab). Action: Change the comparison text to a non-white space character.

Error Messages, 9i Release 2 (9.2.0.2)

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

QSM-02077 materialized view log is newer than last full refreshCause: The capability in question is not supported when the relevant materialized view log was created after the creation or most recent complete refresh of the materialized view. Action: Perform a complete refresh of the materialized view.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00000 to ORA-00899

ORA-00361 cannot remove last log member string for group stringCause: An attempt has been made to remove the last member of a log file group. Action: If desired, delete the entire log, by using DROP LOGFILE.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00251 RETURN, for actual function return, must be last in the parameters clausehold the very last position. Example: The following will give this error since the RETURN … specification for the actual function return in the parameters clause is not the last. FUNCTION myexternalfunc … syntax is the following. Note that RETURN for actual function return is the last specification in

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01190 controlfile or data file string is from before the last RESETLOGSCause: An attempt was made to use a datafile when the log reset information in the file does not match the control file. Either the datafile or the control file is a backup that was made before the most recent ALTER DATABASE OPEN RESETLOGS. Action: Restore file from a more recent backup.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-04100 to ORA-07499

ORA-07245 sfccf: unable to lseek and write the last block.Cause: An attempt was made to move and write to a bad device address. Action: Check errno. Possible lack of space on device.

Error Messages, 9i Release 2 (9.2.0.2)

Recovery Manager Messages (RMAN)

RMAN-06457 UNTIL scn ( string ) is ahead of last scn in archived logs ( string )Cause: UNTIL scn cannot be more than the last scn of the last archived log. Action: Check the UNTIL scn.

Error Messages, 9i Release 2 (9.2.0.2)

SQL*Loader Messages (SQL*Loader)

SQL*Loader-00457 Comparison text of CONTINUEIF LAST must have length 1 not numberCause: The comparison text is too long. It can only be one character. Action: Reduce the comparison text to one character.

Error Messages, 9i Release 2 (9.2.0.2)

SQL*Loader Messages (SQL*Loader)

SQL*Loader-00263 PIECED column string must be last specified column in table stringCause: A column that is not the last column was specified as PIECED. Action: Remove the PIECED keyword or place the column last.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-25185 index column other than last can not be specified for INCLUDE clauseCause: An index column name other than the last was specified as including column. Action: Specify … either a column name which is not part of index-organized table primary key index, or the last key column of the primary key for the INCLUDING clause.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01178 file string created before last CREATE CONTROLFILE, cannot recreateexisted at the last CREATE CONTROL file command. The information needed to re-create the file was lost

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14074 partition bound must collate higher than that of the last partitionthat of the table's last partition, which is illegal. Action: Ensure that the partition bound of … the partition to be added collates higher than that of the table's last partition.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-19331 Last argument to CREATE_DBURI operator must be a columnCause: The final argument to the CREATE_DBURI operator must be a column to which the reference is being created. Action: Specify a valid column name in the query.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00309 with %LAST attribute, ' string ' must be a variable of an enumerated typeCause: The "%LAST" attribute must be applied to an identifier that has been declared as a variable … of an enumerated type (or subtype of an enumerated type). This error occurs when "%LAST" follows … some identifier that has not been so declared. Action: Make sure that %LAST follows an enumerated type (or subtype of an enumerated type).

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00370 OTHERS handler must be last among the exception handlers of a blockmust be the last handler in a block or subprogram because it acts as the handler for all exceptions

Error Messages, 9i Release 2 (9.2.0.2)

ORA-09858 to ORA-12299

ORA-12034 materialized view log on " string "." string " younger than last refreshCause: The materialized view log was younger than the last refresh. Action: A complete refresh is required before the next fast refresh.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-27049 unable to seek to and read the last blockCause: An attempt was made to seek to and read the last block in file, additional information

Error Messages, 9i Release 2 (9.2.0.2)

ORA-01500 to ORA-02099

ORA-01847 day of month must be between 1 and last day of monthCause: The day of the month listed in a date is invalid for the specified month. The day of the month (DD) must be between 1 and the number of days in that month. Action: Enter a valid day value for the specified month.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Command Reference

LISTL[IST] [ n | n m | n *| n LAST|*|* n |* LAST|LAST] Lists one or more lines of the SQL buffer.

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

IBM AIX Event Tests

OutputThe run queue in the last interval.

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

OCI Datatype Mapping and Manipulation Functions, 25 of 134

last_day (OUT)Last day of the month in date.