Question: SQL Programming Report three values found in the PAYINFO table and store them in variables. Output should be: Values are 15, 18.5, 40 DROP TABLE
SQL Programming
Report three values found in the PAYINFO table and store them in variables. Output should be:
Values are 15, 18.5, 40

DROP TABLE EMPLOYEE CASCADE CONSTRAINTS; CREATE TABLE EMPLOYEE ID Name Hours CHARL9) VARCHAR2 (12) NUMBER3) CONSTRAINT PK EMPLOYEE PRIMARY KEY (ID) INSERT INTO EMPLOYEE VALUES (717222144','Daleaz', 30) INSERT INTO EMPLOYEE VALUES'013331902',Jones',50) INSERT INTO EMPLOYEE VALUES'591342771', 'Nesmith',65) INSERT INTO EMPLOYEE VALUES 822182889'", 'Tark', 25) SELECTFROM EMPLOYEE: DROP TABLE PAYINFO CREATE TABLE PAYINEO Regular NUMBER 4, 2), overtime BR 4,2, Cutoff NUMBER12) INSERT INTO PAYINFO VALUES (15.00, 18.50, 40) SELECTFROM PAYINFO: CoMMIT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
