pls explain connect by prior with example and its real time
use
Answer Posted / muhammed zaheer
Connect by prior can be used to create heirarchical tree
structure
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How to manage transaction isolation level?
What is meant by joins? List out the types of joins.
Explain oracle 12c new features for developers?
What is the dynamic sql in oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is the difference between postgresql and oracle?
How to use regular expression in pattern match conditions in oracle?
How to connect asp pages to oracle servers?
What is the difference between I and G in Oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Why use resource manager in Oracle?
what is dynamic SGA and static SGA
Does oracle partitioning improve performance?
Why oracle is used?
How do we get field detail of a table?