Results for LAST


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


SQL Reference, 10g Release 1 (10.1)

LAST

LASTSyntax last::= Description of the illustration last.gif See Also: "Analytic Functions " for … information on syntax, semantics, and restrictions of the query_partitioning_clause Purpose FIRST and LAST … values from a set of rows that rank as the FIRST or LAST with respect to a given sorting specification … . If only one row ranks

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

FIRST/LAST FunctionsThe FIRST/LAST aggregate functions allow you to rank a data set and work with its top-ranked or … any desired column. That is, FIRST / LAST lets you rank on column A but return the result of an … aggregate applied on the first-ranked or last-ranked rows of column B. This is valuable because it avoids … single return value per

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

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

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

FIRST/LAST As Reporting AggregatesYou can also use the FIRST / LAST family of aggregates as reporting aggregate functions. An example … the example in Example 21-15 for FIRST/LAST. What if we wanted to find the list prices of individual … Documentation subcategory by using FIRST/LAST as reporting aggregates. Example 21-16 FIRST/LAST Example 2

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

FIRST/LAST As Regular AggregatesYou can use the FIRST / LAST family of aggregates as regular aggregate functions. Example 21-15 … 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

User's Guide and Reference, 10g Release 1 (10.1)

5 Using 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 that … , FIRST and LAST return NULL. If the collection contains only one element, FIRST and LAST return the … same index value. The following example shows how to use FIRST and LAST to iterate through the

Concepts and Administration, 10g Release 1 (10.1)

14 Monitoring a Streams Environment

Displaying the Last Archived Redo Entry Available to Each Capture ProcessFor a local capture process, the last archived redo entry available is the last entry from the … online redo log flushed to an archived log file. For a downstream capture process, the last archived … redo entry available is the redo entry with the most recent SCN in the last archived log file added to … the last

Error Messages, 10g Release 1 (10.1)

46 NNL-00001 to NNL-01078

NNL-00416: Last timestamp: numberCause: Control program general message. Action: None. NNL-00416: Last timestamp: number

Error Messages, 10g Release 1 (10.1)

62 DRG-10000 to DRG-52210

DRG-50914: invalid last document number stringCause: invalid first document number Action: fix query DRG-50914: invalid last document number string

Error Messages, 10g Release 1 (10.1)

50 NCR-00001 to NCR-04023

NCR-04016: NCRR: Last interface instance handleerror - debug and fix. NCR-04016: NCRR: Last interface instance handle

Error Messages, 10g Release 1 (10.1)

3 ORA-00910 to ORA-01497

ORA-01479: last character in the buffer is not Nulloperation instead. ORA-01479: last character in the buffer is not Null

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14317: cannot drop the last value of partition-issue the command against a List partitoned object. ORA-14317: cannot drop the last value of partition

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14618: cannot drop the last value of subpartitionADD/DROP VALUES is not done on the DEFAULT subpartition ORA-14618: cannot drop the last value of subpartition

Error Messages, 10g Release 1 (10.1)

3 ORA-00910 to ORA-01497

ORA-01209: data file is from before the last RESETLOGSdatabase. Then, either open the database, or execute ALTER SYSTEM CHECK DATAFILES. ORA-01209: data file is from before the last RESETLOGS

Error Messages, 10g Release 1 (10.1)

15 ORA-24280 to ORA-28674

ORA-26089: LONG column " string " must be specified lastto specifying any LOB columns. ORA-26089: LONG column " string " must be specified last

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02077: mv log is newer than last full refreshCause: The timestamp of the sequence number in the mv log was after the last refresh time. Action … : A complete refresh is required before the next fast refresh. QSM-02077: mv log is newer than last full refresh

Error Messages, 10g Release 1 (10.1)

62 DRG-10000 to DRG-52210

DRG-50916: last document string is less than first documentCause: invalid last document number Action: fix query DRG-50916: last document string is less than first document

Error Messages, 10g Release 1 (10.1)

43 TNS-00000 to TNS-12699

TNS-04085: Password not changed since last save.documentation for a list of non-reloadable parameters. TNS-04085: Password not changed since last save.

Error Messages, 10g Release 1 (10.1)

62 DRG-10000 to DRG-52210

DRG-50915: last document number string is not an integerCause: invalid last document number Action: fix query DRG-50915: last document number string is not an integer

Error Messages, 10g Release 1 (10.1)

19 ORA-38029 to ORA-39961

ORA-39312: illegal clean_target() call: last clone operation is failedCause: Operation clone_recovery is illegal here. This can happen if last operation is not a clone … , or is done sucessfully. Action: Apply other appropriate operations. ORA-39312: illegal clean_target() call: last clone operation is failed


Was this page helpful?