Yasser Oracle Blog Dive in Oracle with Yasser, Oracle Developer Courses
Pages
Home
SQL Fundamentals
SQL Fundamentals II
SQL PLUS
PL/SQL
Forms and Reports
HTML5
JavaScript
PHP
jQuery
Java
NLS_LANG
SQL SERVER
PL/SQL Collections and Records
DBMS_OUTPUT built-in package
Date and Time
PL/SQL Transactions
Ref Cursors
Bulk Binds
PL/SQL Analytic Functions
Problems and solves
Oracle Indexes
Oracle Courses
PHP
Work Samples
Record & Collection
LOOP
Conditional statements
Triggers
Object Oriented
Contact Me
Tuesday, March 3, 2020
Oracle tree hierarchical query
In a hierarchical querytraverse the tree from the branch level to the top
select *
from EMP
start with EMPNO = :x
connect by prior MGR = EMPNO;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment