Voina Blog (a tech warrior's blog) #Oracle # SQL Covert view to table issue: ORA-01723: zero-length columns are not allowed
In an Oracle database I was trying to convert an existing view to a table and preserve the data in it. For most of my views the following SQL worked perfectly: CREATE TABLE mytable as select * FROM…
