Mega Code Archive
Search
.Net
ASP .Net
ASP .Net Tutorial
C#
C# Book
C# by API
C# Tutorial
VB.Net
VB.Net by API
VB.Net Tutorial
Visual C++ .Net
VisualBasic Script
Java
Java
Java Book
Java by API
Java Tutorial
Script
Flash ActionScript
Flex
JavaScript DHTML
JavaScript Reference
JavaScript Tutorial
Database
MSSQL
MSSQL Tutorial
MySQL
MySQL Tutorial
Oracle PLSQL
Oracle PLSQL Tutorial
PostgreSQL
Languages
Android
C
C Tutorial
C++
C++ Tutorial
Delphi
Perl
PHP
Python
Python Tutorial
Ruby
Silverlight
Office
MSOfficeExcel 2007 Tutorial
MSOfficePowerPoint 2007 Tutorial
MSOfficeWord 2007 Tutorial
Data
XML
XML Tutorial
Oracle PLSQL
Hierarchical Query 26 codes
Home
Oracle PLSQL
Hierarchical Query
1 Browse Products with three level nested queries
2 Eliminate an entire branch of nodes from the results of a query, you add an AND clause to your CONNECT BY PRIOR clause.
3 Eliminating Nodes and Branches from a Hierarchical Query
4 Employee tree
5 Hierarchical layout
6 Hierarchical Queries
7 Including Other Conditions in a Hierarchical Query
8 LEVEL and the LPAD()
9 Level siblings
10 Lpad( ,2level-2) sys_connect_by_path(lastname, )
11 Output full path of hierarchy
12 Pseudocolumn LEVEL and an example of using the levels
13 Pseudocolumn LEVEL and an example of using the levels with an update
14 SIBLINGS sort applies order to siblings on the same level
15 Sibling layout
16 Sort by LEVEL
17 Starting at a Node Other than the Root
18 Sys_connect_by_path demo
19 Sys_connect_by_path function
20 Sys_connect_by_path function will take any column
21 Sys_connect_by_path in hierarchical query
22 Sys_connect_by_path(lastname, )
23 Traversing Upward Through the Tree
24 Use the COUNT() function and LEVEL to get the number of levels in the tree
25 Using a Subquery in a START WITH Clause
26 Using the LEVEL Pseudo-Column