ERICKA I. SANTOS Activity Sheet 05A
BSCS ND 2B
Determine if the following declarations are valid. Write VALID, if the
declaration is correct, if not, write INVALID and make the declarations correct.
VALID 1. DECLARE
v_empno NUMBER;
INVALID Contact_name NAME; 2. DECLARE
Contact_name DATE;
INVALID Product_name NAME; 3. DECLARE
Productname NUMBER;
INVALID Creditlimit NUMBER; 4. DECLARE
Creditlimit DATE;
INVALID Shipping_status Varchar2(25); 5. DECLARE
Shipping_status NUMBER;
VALID 6. DECLARE
Hired DATE;
VALID 7. DECLARE
Productcode NUMBER;
VALID 8. DECLARE
Business_partner Varchar2 (255);
INVALID Customer_name NAME; 9. DECLARE
Customer_name Varchar2 (25);
INVALID Deliverydate DATE; 10. DECLARE
Deliverydate NUMBER;
