Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Unanswered: what is pseudo column level???? where we can use it

    In oracle, that is in sql, level is one of the pseudo column i wnat to know about level and usage???

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    when all else fails Read The Fine Manual

    Pseudocolumns
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Your link doesn't actually contain any info on LEVEL.

    Level is used for recursive "connect by" queries, to indicate the level of recursion.
    http://download.oracle.com/docs/cd/B...1.htm#i1009261

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    "LEVEL Pseudocolumn

    For each row returned by a hierarchical query, the LEVEL pseudocolumn returns 1 for a root row, 2 for a child of a root, and so on. A root row is the highest row within an inverted tree. A child row is any nonroot row. A parent row is any row that has children. A leaf row is any row without children. Figure 3-1 shows the nodes of an inverted tree with their LEVEL values."

    I guess I am just imagining things again.

    SORRY about sharing my wishful thoughts

    http://download.oracle.com/docs/cd/B...1.htm#i1009313
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •