INTERVIEW QUESTIONS
ORACLE
SQL IN ORACLE
DETAILS
Question: What is a pseudo column. Give some examples?
Answer: It is a column that is not an actual column in the table. eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.
|
Question:
What is a pseudo column. Give some examples?
Answer:
It is a column that is not an actual column in the table. eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL. Source: CoolInterview.com
pseudo column is a column that is not present in the database. it is used for unique identification of rows like ROWNUM,ROWID,LEVEL,NEXTVAL,CURVAL,NULL etc. Source: CoolInterview.com
Answered by: sudipta das | Date: 4/18/2008
| Contact sudipta das
example of pseudo columan: SQL> SELECT uid, user FROM dual; UID USER ---------- ------------------------------ 50 MICHEL Source: CoolInterview.com
Answered by: sarika datir | Date: 8/20/2010
| Contact sarika datir
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|