SQL Plus - What are the more common pseudo-columns

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 47 of 132

What are the more common pseudo-columns

Answer posted by Scott on 2005-05-25 18:43:29: SELECT rownum, rowid
FROM sometable

Total Answers and Comments: 6

Last Update: June 24, 2008

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

May 25, 2005 18:43:29

Scott

RE: What are the more common pseudo-columns

SELECT rownum rowid
FROM sometable

Is this answer useful? Yes | No

August 24, 2005 19:54:35

PALLAVI

RE: What are the more common pseudo-columns

ROWNUM ROWID LEVEL

Is this answer useful? Yes | No

November 24, 2005 05:35:17

Venu.

RE: What are the more common pseudo-columns

PALLAVI Wrote: ROWNUM ROWID LEVEL

The common pseudo coumns are Rowid Rownum level nextval curval..

Is this answer useful? Yes | No

December 16, 2005 08:51:57

Venugopal Chowdary.M

RE: What are the more common pseudo-columns

The most commonly used psuedo columns are sysdate rowid

Is this answer useful? Yes | No

March 24, 2006 11:11:20

na123

Member Since: March 2006 Contribution: 10

RE: What are the more common pseudo-columns

common pseudo-columns-

Rownm Rowid Level Currval Nextval

Is this answer useful? Yes | No

June 24, 2008 11:52:43

sweetytrivedi

Member Since: June 2008 Contribution: 7

RE: What are the more common pseudo-columns

Besides these the other pseudo columns are:

user uid

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank