Page 1 of 1

Description Instructions These two tables are for Question 1 - 14: Branch branchNo street city postCode B005 B007 B003 B

Posted: Sun May 15, 2022 8:02 am
by answerhappygod
Description Instructions These Two Tables Are For Question 1 14 Branch Branchno Street City Postcode B005 B007 B003 B 1
Description Instructions These Two Tables Are For Question 1 14 Branch Branchno Street City Postcode B005 B007 B003 B 1 (705.47 KiB) Viewed 36 times
Q2. Define a cursor "cursorStaff" on Staff table with a
parameter vSalary. It should gives access to all the data on the
staff whose salary is vSalary
Description Instructions These two tables are for Question 1 - 14: Branch branchNo street city postCode B005 B007 B003 B004 BOO2 22 Deer Rd London SWI 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow G11 9QX 32 Manse Rd Bristol BS99 INZ 56 Clover Dr London NW10 6EU Staff staffNo Name IName position sex DOB salary branch No White Beech Ford SL21 SG37 SG14 SA9 SG5 SL41 John Ann David Mary Susan Julie Manager M Assistant F Supervisor M Assistant F Manager F Assistant F. 1-Oct-45 10-Nov-60 24-Mar-58 19-Feb-70 3-Jun-40 13-Jun-65 30000 B005 12000 B003 18000 B003 9000 B007 24000 B003 9000 B005 Howe Brand Lee