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

SQL Programming Report three values found in the PAYINFO table and store

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!