PL/SQL (MOSC)

MOSC Banner

How do i fix this.

in PL/SQL (MOSC) 2 commentsAnswered

I created the plsql code below and it was successful, but it will only insert into the table, it does not return the values when the numjob is greater than 3. How do i fix it


CREATE OR REPLACE PROCEDURE pub_detail IS

CURSOR publisherCursor is

SELECT publisher.publishername,city, phonenumber, COUNT(printjob.publishername) as numjob

FROM publisher, printjob

WHERE publisher.publishername = printjob.publishername

GROUP BY publisher.publishername, citY, phonenumber;

tempRec publisherCursor%Rowtype;

CURSOR printjobCURSOR IS

SELECT publisher.publishername, jobno, startdate, completiondate, count(publishername) as numjob

FROM publisher, printjob

WHERE publisher.publishername = printjob.publishername

GROUP BY publisher.publishername, jobno, startdate, completiondate;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center