Hi Pavel, I have found an issue with the 'J' format of the oracle.to_date (text, text) function, it reports wrong results compared to Oracle. On Oracle: SQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM ...

In oracle, if you pass string data to a field of type NUMBER, it will cause oracle to cast, affecting the efficiency of sql execution. Similarly, if you pass TIMESTAMP type data to a field that needs ...

Hello, I need help with a Oracle SQL query. I have two tables, with data similiar to the following: One 'student' table with a date that the student registered and one 'semester' table with ...