1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / abc

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

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

549

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1600

How to install oracle odbc drivers?

619

Explain integrity constraint?

641

How to convert characters to dates in oracle?

559




How to display row numbers with the records?

584

How to use existing values in update statements using oracle?

545

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1741

What is a static data dictionary in oracle?

564

What is a package in oracle?

562

How to synchronize 2 schema's objects?

1682

How to execute a stored program unit?

578

How to create a stored program unit?

576

Can we commit inside a function in oracle?

556

How do I start tns listener?

538