Discussion Board

incorrect correct answer The key word in the "A pseudocolumn is also similar to a function without arguments" statement is "similar". If we take a closer look at the definition of pseudo-columns we will notice the following: "However, functions without arguments typically return the same value for every row in the result set, whereas pseudocolumns typically return a different value for each row." SYSDATE as well as USER will always return same value for every row selected from a table, always. Nick 08-21-2014 05:16 AM

pseudocolumn A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot insert, update, or delete their values. A pseudocolumn is also similar to a function without arguments SQL and PL/SQL recognizes the following SQL pseudocolumns, which return specific data items: SYSDATE, SYSTIMESTAMP, ROWID, ROWNUM, UID, USER, LEVEL, CURRVAL, NEXTVAL, ORA_ROWSCN, etc. career 08-21-2014 04:04 AM

incorrect correct answer SYSDATE and USER are not pseudo-columns. SYSDATE is a function, so is USER. Nick 08-21-2014 03:45 AM

explain ans row num and row id are the pseudo columns but ans is sysdate,user,curval,nextval Bhakti 06-26-2014 08:37 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*