level [Oracle SQL]

level is a pseudo column that can be used in hierarchical queries (start with .. connect by).

For records that appear in the root, level is 1, for their (direct) children, level is 2 and so on.