Question: Step 1: Insert a record in the employee (EMP) table such that employees first and last names are your own first and last names. Data

Step 1: Insert a record in the employee (EMP) table such that employees first and last names are your own first

and last names. Data for all other columns should be fictitious. Date of birth of this employee should be after

1980.

Step 1: Insert a record in the employee (EMP) table such that employees first and last names are your own first

and last names. Data for all other columns should be fictitious. Date of birth of this employee should be after

1980.

Using Oracle Live SQL

Step 1: Insert a record in the employee (EMP)

Step 1: Insert a record in the employee (EMP)

Schema EMP Syntax Help Show All Table Attributes Columns Indexes Triggers Constraints Columns Column Type Length Precision Semantics Scale Nullable EMP NUM NUMBER 22 No Yes 10 Byte 2 EMP_TITLE CHAR 3 VARCHAR2 15 No Byte EMP_NAME No EMP FNAME 15 Byte VARCHAR2 5 CHAR Yes EMP INITIAL 1 Byte 7 6 DATE Yes EMP DOB 7 EMPHIRE DATE DATE Yes 7 CHAR EMP AREACODE Yes 3 Byte 9 EMP PHONE CHAR 8 Yes Byte 10 NUMBER Yes EMP MGR 22 CREATE TABLE EMP ( EMP_NUM NUMBER PRIMARY KEY, EMP_TITLE CHAR(10), EMP_LNAME VARCHAR(15) NOT NULL, EMP_FNAME VARCHAR(15) NOT NULL, EMP_INITIAL CHAR(1), EMP DOB DATE, EMP_HIRE_DATE DATE, EMP_AREACODE CHAR(3), EMP PHONE CHAR(8), EMP_MGR NUMBER)

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 General Management Questions!