When attempting to display a full month in Oracle, it adds spaces by default, up to the length of the maximum month.
This occurs when using
You could wrap that with a trim function call, or you could use
Select from a table at a certain point in history. This can be useful if you have made a mistake and edited or deleted data. Be careful though, because you have to have flashback enabled, and also set with enough space to capture all the changes that you need to recover.
Any DDL on the table will reset the ability to flashback.
AS OF TIMESTAMP SYSDATE - time_unit;