Question: Q 1 . Given the database described by the following tables: STORE ( STNO , Address, Surface ) PRODUCT ( PNO , DesProd, color, Weight,
Q Given the database described by the following tables:
STORE STNO Address, Surface
PRODUCT PNO DesProd, color, Weight, QtyStk QtyMin, Price, STNO#
Write a PLSQL block that uses an implicit cursor to check that Store exists and then inserts the new product 'TABLE', 'WHITE',
Q Given the following table
EMP Empno Ename, SAL, Comm, Deptno#
Develop a trigger that records any change of salaries done during the working days assumed as days and into the table:
AUDITEMPSALUname ActionDate, OldSal, NewSal, DayNo
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
