SQL - Explain psudo column Label with an example

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 79 of 171

Explain psudo column Label with an example

Total Answers and Comments: 5

Last Update: February 06, 2008 Asked by: prafull.vn

Sponsored Links

Best Rated Answer

—

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

March 23, 2006 23:22:00

prafull.vn

Member Since: March 2006 Contribution: 10

RE: Explain psudo column Label with an example

I m sorry for typing mistake ... I want to Know About LEVEL

Is this answer useful? Yes | No

March 24, 2006 05:26:59

Nikhil

RE: Explain psudo column Label with an example

Pseduo columns are columns which have special meaning. Though we do not define in create table but we can access those columns in our queries like

ROWNUM

ROWID

NEXTVAL

CURRVAL

Hope so this in line with question req.

Nikhil Wani

Vadodara

Is this answer useful? Yes | No

May 03, 2006 16:39:19

Tatyana

RE: Explain psudo column Label with an example

Hi all SQL-lovers

'pseudo' means 'false; not genuine'.

ROWNUM is 'pseudo' column that means rownum values are not holded at any place in a table.

On the contrary every row in a table has its own address which is kept in the column 'ROWID'. 'ROWID' is not a 'pseudo' column.

Is this answer useful? Yes | No

May 04, 2006 21:05:05

Tatyana

RE: Explain psudo column Label with an example

Sorry sorry I am wrong. Rowid is a pseudocolumn.

Is this answer useful? Yes | No

February 06, 2008 23:30:35

g_sidhu

Member Since: August 2007 Contribution: 122

RE: Explain psudo column Label with an example

LEVELYou use LEVEL with the SELECT CONNECT BY statement to organize rows from a database table into a tree structure. LEVEL returns the level number of a node in a tree structure. The root is level 1 children of the root are level 2 grandchildren are level 3 and so on.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank