How to perform an inner join in PL/SQL on two or more tables?

 

SELECT tbl_category.name, tbl_product.product_title
FROM tbl_product
INNER JOIN tbl_category ON tbl_category.category_id = tbl_product.category_id;

Another method

DECLARE
  CURSOR join_cursor IS
    SELECT tbl_category.name, tbl_product.product_title -- Selecting name from tbl_category and product_title from tbl_product tables
    FROM tbl_product
    INNER JOIN tbl_category ON tbl_category.category_id = tbl_product.category_id; -- Joining the tbl_category and tbl_product tables on category_id

BEGIN
  FOR join_record IN join_cursor LOOP -- Looping through each record fetched by the cursor
    DBMS_OUTPUT.PUT_LINE(join_record.name || ' ' || join_record.product_title); -- Printing the name and product_title of each record
  END LOOP;
END;