Thanks for the question, SanthoshKumar.
Asked: June 20, 2020 - 5:48 am UTC
Last updated: July 01, 2020 - 1:58 am UTC
Version: 11.2
Viewed 1000+ times
SELECT * FROM GTT_TAB1 AS OF TIMESTAMP TO_TIMESTAMP('2005-04-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
insert into GTT values (1); rollback; <<=====
Santhosh, June 30, 2020 - 4:47 am UTC
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library