using self join and group by function...

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

Question Posted / abc

Answer Posted / abc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2419

Are truncate and delete commands same? If so why?

1199

How to end the current transaction in oracle?

1066

How do I limit the number of oracle database connections generated by weblogic server?

1113

How to define a cusotmer as a supplier in ORACLE R12

2297

How to call a stored function with parameters?

1089

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1161

How to list all indexes in your schema?

1140

query optmization techniques and quwry analyser+projects+ppts

2463

Why cursor variables are easier to use than cursors?

1137

Explain the use of indexes option in imp command.

1256

What is a server parameter file in oracle?

1094

How do I spool to a csv formatted file using sqlplus?

1083

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

1128

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2202