Explain psudo column Label with an example

Questions by prafull.vn   answers by prafull.vn

Showing Answers 1 - 5 of 5 Answers

Nikhil

  • Mar 24th, 2006
 

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

  Was this answer useful?  Yes

Tatyana

  • May 3rd, 2006
 

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.

  Was this answer useful?  Yes

Tatyana

  • May 4th, 2006
 

Sorry, sorry, I am wrong. Rowid is a pseudocolumn.

  Was this answer useful?  Yes

g_sidhu

  • Feb 6th, 2008
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions