Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.

Question Posted / sharad kumar

Answers were Sorted based on User's Feedback



A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to c..

Answer / sharad kumar

select manager name,employee name,level
from table_name
start with manager name is null /* optional*/
connect by prior nocycle employee name = manager name
/*Child = Parent */

Is This Answer Correct ?    20 Yes 0 No

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to c..

Answer / sankar

select manager name,employee name,level from table_name
start with manager_name is null/* optional */ connect by prior
no cycle employee name=manager name/*child=parent*/

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

How is use pl and sql?

0 Answers  

Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

How do I remove sql plus from windows 10?

0 Answers  

Can I join the same table twice?

0 Answers  

How do I view stored procedures?

0 Answers  

Write a query to get last 10 records from the table.

12 Answers   iNautix,

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

What is the difference between numeric and autonumber?

0 Answers  

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

what is datawarehouse? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories