Following type of SQL’s can cause “subquery in FROM must have an alias” issue. They are like below, It needs to be fixed to meet the SQL standards. There is no question asked about why PostgreSQL did not support 🙂 why should I create alias in all the cases 🙂… Continue Reading ORA2PG MIGRATION – Subquery must have an alias

The code like this in your program can throw “Data Type Mismatch Error” at run time. Following is the actual runtime error will come in the application, Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: smallint <> character varying  Hint: No operator matches the given name and argument types. You… Continue Reading Ora2Pg Migration – Data Type Mismatch Error