Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
select
This is a discussion on select within the SQL forums, part of the Databases category; Can any one tell me why and when do we use CONNECT BY clause in a select statement...
|
|||||||
01-12-2009
|
|||
|
|||
|
Re: select
Connect by clause is used to select the data that has a hierarchical relationship.
Ex: Boss-Employees, Parent-Children etc To learn more about this:- 
|
| The Following User Says Thank You to chaitra murthy For This Useful Post: | ||
|
01-12-2009
|
|||
|
|||
|
Re: select
Connect by clause is maily used to fetch the hierarchical data from the database. Its basically used to denote the parent child relationship.
Few of them are: 1. Employee - manager 2. Main menu - sub menus 3. Business unit - sub business units you can check more on connect by clause here and here hope this helps
|
| The Following User Says Thank You to amitpatel66 For This Useful Post: | ||
|
01-13-2009
|
|||
|
|||
|
Re: select
I found this link very useful for
Hierarchical queries
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Confused to select whether mba or mca | vivinkarthik | Career Advice | 1 | 08-13-2008 02:08 AM |
| Is Select DML? | karthizen | Oracle | 6 | 06-11-2008 11:21 PM |
| select * from | jayanth511 | SQL | 4 | 03-04-2008 11:10 PM |
| SELECT statement... | nitin_padwal | Oracle | 2 | 01-10-2008 08:50 AM |
| Select within select | neeraj_sigh | SQL | 7 | 12-09-2007 04:59 AM |
All times are GMT -4. The time now is 04:24 PM.
