• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

get all the records from a child table ?

 
vianyrajnish rajnish
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic