Recent content by czn

It would be nice if we could restructure tables without losing data. Of course this is not an one shot Oracle command, but you could generate a script instead, something like rename table, create a new table having the new structure, copy old data etc. This is what we manually do now in order to...

I had a similar problem with ODBC: I exported from Access through an ODBC connection into an Oracle DB. In PLSQLDev,Select * from myTable worked fine but Select col from MyTable didn't(column not found error). In Access,I uppercased the columns and table names, re-export in Oracle and worked...