how to make this pl/sql statement run to generate output of job name and skill

C

chin

New member
description?? any hints ? i have this following pl/sql trigger to be solve:-

CREATE OR REPLACE TRIGGER


DECLARE


BEGIN
-- execution of sql statement
SELECT JobName, Skill_description
FROM Skills, Job
WHERE Job.Job_id=Skills-Job.Job_id
AND Skills-Job.Skill_id=Skills.Skill_id
AND (JobName LIKE '%PHP%' AND Skill_description LIKE '%PHP%');


-- exception
/* what exception should i put pls advice ! */



END;
/

any recommendation, pls do so

tq!
 
Back
Top