PSEUDOCOLUMNS


  • ROWID Relative row pointer.

  • ROWNUM A sequence number for rows returned by a query as the rows are returned.

  • <sequence>.CURRVAL and <sequence>.NEXTVAL The current and next values for a sequence.

  • LEVEL Returns the level of a row in a hierarchical query.



    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net