Level - sql pseudocolumns, PL-SQL Programming

LEVEL

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

You specify the direction in which the query walks the tree with the PRIOR operator. In the START WITH phrase, you specify a condition which identifies the root of the tree.

Posted Date: 10/4/2012 3:42:08 AM | Location : United States







Related Discussions:- Level - sql pseudocolumns, Assignment Help, Ask Question on Level - sql pseudocolumns, Get Answer, Expert's Help, Level - sql pseudocolumns Discussions

Write discussion on Level - sql pseudocolumns
Your posts are moderated
Related Questions
Creating a Table Syantax: CREATE TABLE ENROLMENT (StudentId SID, Name   VARCHAR (30) NOT NULL, CourseId CID, PRIMARY KEY (StudentId, CourseId)) ; Explan

Literature review

Recursion The Recursion is a powerful method for simplify the design of the algorithms. Principally, the recursion means the self-reference. In the recursive mathematical serie

Providing Results of Queries Expressing queries in SQL is the (big) subject. Here I present just a simple example to give you the flavour of things to come in those chapters.

Bitmap Join Indexes - This feature will increase the performance and detains the size and format of your databases in data Character Semantics and Globalization -This featur

Example of NOT EXISTS in SQL Example: Use of NOT EXISTS CREATE ASSERTION Must_be_enrolled_to_take_exam_alternative1 CHECK ( NOT EXISTS (SELECT StudentId, CourseId

Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b

Using Invoker Rights: By default, the stored procedure executes with the privileges of its definer, not its invoker. These procedures are bound to the schema in which they inh

Need Azure CRM Web Application with two-factor authentication We presently have a CRM-like database stored on MS Azure that we presently access over an MS Access application. It

Organi c Evolution Evolution is a slow continuous, irreversible and natural process of change to give rise to advance and diverse forms of life i.e. formation of new specie