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


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
Get step-by-step solutions from verified subject matter experts
