ora-00905

SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword

In Oracle we don’t include the AS when declaring a table alias. Instead of ) AS TABLE_RESOLVERS write ) TABLE_RESOLVERS This is one example when Oracle syntax is more restrictive than some other flavours of SQL. It is also inconsistent with the declaration of column aliases, which is unfortunate but almost certainly it’s too complex … Read more

SELECT INTO using Oracle

If NEW_TABLE already exists then … insert into new_table select * from old_table / If you want to create NEW_TABLE based on the records in OLD_TABLE … create table new_table as select * from old_table / If the purpose is to create a new but empty table then use a WHERE clause with a condition … Read more