CURRENT_TIMESTAMP Function In Oracle
CURRENT_TIMESTAMP is one of the vital Date/Time functions of Oracle. It is used to get the current date and time in the time zone of the current SQL session. The CURRENT_TIMESTAMP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.
Select CURRENT_TIMESTAMP from dual;
26-Jun-19 18.104.22.1683745 PM -07:00
The result will be the current timestamp in the time zone of the current SQL session.