Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Joining Two Tables In PL/SQL

829538Jan 16 2011 — edited Jan 17 2011
I'm trying to display a tuple from 2 tables but I am having issues trying to join them. This is what I have, assuming order.ord_id references product.prod_id
DECLARE
    	orderrec	order%ROWTYPE;
BEGIN
	SELECT 	* 
	INTO 	orderrec	
    	FROM  	order, product
    	WHERE 	order.ord_id = product.prod_id;
	
END;
Can anyone explain why this is not working? Is there a different way of joining in PL/SQL?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2011
Added on Jan 16 2011
7 comments
2,970 views