By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table "employee" (
"emp_id" VARCHAR2(100 BYTE),
"emp_name" VARCHAR2(100 BYTE),
"hired_date" Date,
CONSTRAINT "PK_employee" PRIMARY KEY ("emp_id")
);
Insert into "employee" values ( 'A1234', 'John Day', TO_DATE('07/20/2020 15:05:20', 'MM/DD/YYYY HH24:MI:SS'));
1 rows affected
select * from "employee";
| emp_id | emp_name | hired_date |
|---|---|---|
| A1234 | John Day | 20-JUL-20 |