Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Error: ORA-01723: zero-length columns are not allowed

user13034857Oct 1 2013 — edited Oct 1 2013

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2013
Added on Oct 1 2013
2 comments
1,905 views