Hello, this is for Oracle SQL. reate the fol Towing tab le and insert values in

Question

Hello, this is for Oracle SQL.

reate the fol Towing tab le and insert values in 1t according to following table Note: Employees is work table for these queries Table: Employees Employee First_Name Last Name Dept Code Credit Limit Phone Manager_id Ext Hire_Date Id 201 202 203 204 205 206 207 208 209 210 Brown Kern Woods Owens Perkins Rose Smith Campbel1 Jacobs Hoffman 01-Jun-1998 16-Aug-1999 02-Feb-2004 01-Jul-2003 01-Mar-2000 nu1l 01-Dec-2004 01-Apr-2003 17-Mar-1999 16-Feb-2004 $30.00 $25.00 $25.00 $15.00 $25.00 null $25.00 $30.00 $15.00 $25.00 3484(nul1) 8722 7591 6830 5286 null (nul1) 2259 1752 3357 2974 Susan Exe Sa l 201 201 202 202 1 m Martha Ellen Hen Caro Dan Fred Paula Nancy Sa Sal Act Shp Shp Mkt 203 203 201 203

Explanation / Answer

CREATE TABLE Employees

(

EmployeeId   NUMBER(10) PRIMARY KEY,

First_Name   VARCHAR2(15) NOT NULL,

Last_Name    VARCHAR2(15) NOT NULL,

DeptCode     VARCHAR2(5) NOT NULL,

Hire_Date    DATE,

Credit_Limit NUMBER(5,2),

PhoneExt      NUMBER(20),

Manager_id   NUMBER(10));

Now with above command executed we will have Employees table ready and now we will go for insert commands

INSERT INTO tablename(column1,..column)

   VALUES (value1,...valuen);

1) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (201, 'Susan', 'Brown', 'Exe', TO_DATE('01-Jun-1998','DD-MON-YYYY'), 30, 3484, NULL );

2) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (202, 'Jim', 'Kern', 'Sal', TO_DATE('16-Aug-1999', 'DD-MON-YYYY'),25,8722,201);

3) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (203,'Martha','Woods','Shp',TO_DATE('02-Feb-2004','DD-MON-YYYY'),25,7591,201);

4) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (204,'Ellen','Owens','Sal',TO_DATE('01-Jul-2003’,'DD-MON-YYYY'),15,6830,202);

5) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (205,'Henry','Perkins','Sal',TO_DATE('01-Mar-2000’,'DD-MON-YYYY'),25,5286,203);

6) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (206,'Carol','Rose','Act',NULL,NULL,NULL,NULL);

7) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (207,'Dan','Smith','Shp',TO_DATE('01-Dec-2004’,'DD-MON-YYYY'),25,2259,203);

8) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (208,'Fred','Campbell','Shp',TO_DATE('01-Apr-2003’,'DD-MON-YYYY'),30,1752,203);

9) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (209,'Paula','Jacobs','Mkt',TO_DATE('17-Mar-1999’,'DD-MON-YYYY'),15,3357,201);

10) INSERT INTO Employees (EmployeeId, First_Name, Last_Name, DeptCode, Hire_Date, Credit_Limit, PhoneExt, Manager_id)

VALUES (210,'Nancy','Hoffman','Sal',TO_DATE('16-Feb-2004’,'DD-MON-YYYY'),25,2974,203);

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.