Get the Current Date for PL/SQL
This is not really a post, just a small note on an item that can make you lose precious time hunting for… To get the current date in a PL/SQL query in order to compare it with other fields or data from the Oracle database, do this: select extract(year from sysdate) from dual This gets [...]
Full Story