Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i want to mele a trigger function i have table named repairjob and a column customer_cpr , please help me find where is my mistake

i want to mele a trigger function i have table named repairjob and a column customer_cpr , please help me find where is my mistake
image text in transcribed
image text in transcribed
1. CREATE OR REPLACE TRIGGER trg_prevent_multiple_repair_jobs 2 BEFORE INSERT OR UPDATE ON REPAIRJOB 3 FOR EACH ROW 4 BEGIN IF (SELECT COUNTT ) FROM REPAIRJOB WHERE CUSTOMER_CPR = :new.CUSTOMER_CPR) >3 THEN RAISE_APPLICATION_ERROR(-20001, 'Customer cannot have more than 3 repair jobs' ); END IF; 8 END; - ( * 8.8+;1 at for mod remainder rem can exponent (**)> and or group having intersect minus order start union where connect || indicator multiset Error at line 2: PLS-BB103: jeji 4?1 g pa "SELECT" qutiti Eig tis: ( - + case inod new not null can identifiers sa double-quoted delinited-identifiers

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical And Scientific Database Management International Working Conference Ssdbm Rome Italy June 21 23 1988 Proceedings Lncs 339

Authors: Maurizio Rafanelli ,John C. Klensin ,Per Svensson

1st Edition

354050575X, 978-3540505754

More Books

Students also viewed these Databases questions

Question

What is Aufbau's rule explain with example?

Answered: 1 week ago