get all the records from a child table ?

[vianyrajnish rajnish]

Hi all,

I have a parent-child relation between tables in oracle .

Is there any way to get all the child records by giving the primary key of the parent table.

can any body give an idea to me ....

Thanks
Vinay rajnish

[Shailesh Chandra]

Yes,A simple join will solve your problem, but all the column value of parent table will repeated for every row of child table.

Shailesh