Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

get all the records from a child table ?  RSS feed

 
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: 1084
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
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!