SQL Data Types Oracle PLSQL Tutorial

The TIMESTAMP WITH LOCAL TIME ZONE type extends TIMESTAMP to store a timestamp in the local time zone.
When you supply a timestamp for storage in a TIMESTAMP WITH LOCAL TIME ZONE column, your timestamp is converted-or normalized-to the time zone set for the database.
If you then retrieve the timestamp, it is normalized to the time zone set for your session.