i've got an oracle problem, here is my select:
create table new_table as select idprod as product_id, descr as description from old_table p where updateNum = (select max(updateNum) from old_table pp where pp.idprod = p.idprod);
this query gives me one generic error with no explanation. SQL Developer say me: "Error starting at line 7 in command: [...] Error report: SQL Command: create table Failed: Warning: execution completed with warning" but create the table and the data inside seems to be correct.
Some hints? Thanks