I want to create a table 'EMP_TEST' FROM EMP table and to have a new column example job_end_date with no value.
create table emp_test as
(SELECT
ename
,eid
,sal,
,null job_end_date -------------------> New field and it will have no value
from emp);
when I am creating this table I am getting following error
'SQL Error: ORA-01723: zero-length columns are not allowed'
How can I resolve this issue.
Thanks in advance.
I really want to have it fast.