How to display the hierarchy of employee and managers
without using connect by prior.

Answer Posted / abc

using self join and group by function...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of grant option in imp command.

660


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1713


what is the use of system.effective.date variable in oracle?

758


What is a package in oracle?

656


if you ctreate table identity

1971






What is a database schema in oracle?

729


How to use group functions in the select clause using oracle?

673


What are the advantages of oracle?

658


What do you mean by merge in oracle?

675


Is insert autocommit in oracle?

684


How to rename an index?

668


What is Data Dictionary Cache in Oracle?

757


Explain the use of consistent option in exp command.

625


What is materialized view in Oracle?

716


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2006