Default constraint on getdate() not working [duplicate]
Solution 1:
GETDATE() is a SQL Server function for the current date, is not supported by Oracle. You may use sysdate instead:
CREATE TABLE Emp (
Empno number(4),
Ename varchar2(20),
Job varchar2(20),
Hire_date date default sysdate
);