--Procedure list_campaigns(cname in campaign.companyname%Type)--
CREATE OR REPLACE PROCEDURE list_campaign
	(cname IN campaign.companyname%Type)
IS
	CURSOR list_campaign_cur IS
		SELECT title, estimatedcost, actualcost
		FROM campaign;
BEGIN
	FOR list_campaign_rec IN list_campaign_cur LOOP
		IF cname = campaign.companyname THEN
			DBMS_OUTPUT.PUT_LINE( list_campaign_cur.TITLE || ' ' || 'Estimated Cost: ' || list_campaign_cur.estimatedcost || ' ' ||
			' Actual Cost: ' || list_campaign_cur.actualcost );
		END IF;
	END LOOP;
END;
/

CREATE OR REPLACE PROCEDURE list_campaign (cname IN campaign.companyname%TYPE)
IS
   CURSOR list_campaign_cur
   IS
      SELECT title, estimatedcost, actualcost, companyname
        FROM campaign;
BEGIN
   FOR list_campaign_rec IN list_campaign_cur
   LOOP
      IF cname = list_campaign_rec.companyname
      THEN
         DBMS_OUTPUT.put_line (   list_campaign_rec.title
                               || ' '
                               || 'Estimated Cost: '
                               || list_campaign_rec.estimatedcost
                               || ' '
                               || ' Actual Cost: '
                               || list_campaign_rec.actualcost
                              );
      END IF;
   END LOOP;
END;

CREATE OR REPLACE PROCEDURE list_campaign (cname IN campaign.companyname%TYPE) IS
   CURSOR list_campaign_cur (p_company IN campaign,companyname%type) IS
     SELECT title, estimatedcost, actualcost, companyname
     FROM   campaign
     WHERE  companyname = p_company;
BEGIN
   FOR list_campaign_rec IN list_campaign_cur(cname) LOOP
     DBMS_OUTPUT.put_line (   list_campaign_rec.title
                           || ' '
                           || 'Estimated Cost: '
                           || list_campaign_rec.estimatedcost
                           || ' '
                           || ' Actual Cost: '
                           || list_campaign_rec.actualcost
                          );
   END LOOP;
END;