Keep it simple and stick to basics
Both Oracle and PostgreSQL supports Date as the data type. However there is a difference, In oracle date includes timestamp and in case of PostgreSQL it gives only date omitting timestamp. It is mainly because PostgreSQL has we have another data type called “Timestamp”. Having said that, If you are using JPA annotation @Temporal in…
While converting application from Oracle to PostgreSQL database and if the application uses procedure, following might be one of the exception you should have seen, Caused by: org.postgresql.util.PSQLException: ERROR: getCalculatedValues() is a procedure Hint: To call a procedure, use CALL. The following line of code might exists in your code base, While calling procedures…
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 🙂 The correct query with 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 might need to add explicit…
If you face Insufficient privileges issue while connecting to oracle database from Amazon AWS Schema Conversion Tool (SCT) like below, ORACLE Server : [SELECT ANY DICTIONARY] Run following command as system user in oracle server, grant select any dictionary to abc_owner;