Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2007
    Posts
    12

    Question Unanswered: Pseudo columns in Oracle?

    Hi friends,

    Recently I attended an interview in which they have asked about pseudo columns.

    The exact question is as follows:
    What are pseudo columns in Oracle?

    Can anybody give the perfect reply....? Please...

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Pseudocolumns behave like table columns, but are not stored in a table. Their value can only be selected (not updated, inserted or deleted). ROWNUM and ROWID are probably the most popular pseudocolumns in Oracle. Read more about them in the SQL Reference book.

  3. #3
    Join Date
    Mar 2007
    Posts
    4

    Pseudo Columns in Orcale

    The Pseudo columns in oracle are Rownum,Rowid,sysdate are some of the
    Pseudo columns in oracle

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    SYSDATE is NOT a pseudocolumn; it is a function.

  5. #5
    Join Date
    Jun 2007
    Posts
    12

    Post

    Quote Originally Posted by Littlefoot
    SYSDATE is NOT a pseudocolumn; it is a function.

    Pseudo Columns in Oracle as follows:
    • ROWID
    • ROWNUM
    • CURRVAL
    • NEXTVAL
    • LEVEL, etc..


    Sysdate is a Oracle function.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •