Question: These 2 codes are written in Oracle it needs to be changed to work in MS Access: 1. CREATE SEQUENCE CUST_NUM_SQ START WITH 1000 NOCACHE;
These 2 codes are written in Oracle it needs to be changed to work in MS Access:
1. CREATE SEQUENCE CUST_NUM_SQ START WITH 1000 NOCACHE; CREATE SEQUENCE INV_NUM_SQ START WITH 5000 NOCACHE;
2. UPDATE CUSTOMER SET CUST_DOB = 15-MAR-1979 WHERE CUST_NUM = 1000;
UPDATE CUSTOMER SET CUST_DOB = 2-DEC-1988 WHERE CUST_NUM = 1001;
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
Study Help