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!

Create table from select

Paras BawejaJul 1 2015 — edited Jul 1 2015

Hi guys,

There is a problem I'm facing I have to create the table from the select statement resulting 0 records as output.

Sue to which, the error displayed is:

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

01723. 00000 - "zero-length columns are not allowed"

*Cause: Columns with zero length were not allowed.

*Action: Correct the use of the column.

no rows selected

Can you please suggest the possible way?

I have to create multiple tables like this from the select statement.

This post has been answered by BluShadow on Jul 1 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 29 2015

Added on Jul 1 2015

20 comments

6,209 views