cenkc/as-of-timestamp.sql

Created December 10, 2019 19:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/cenkc/59d6e4ccb48e17f64258ccda6f5d8407.js"></script>
Save cenkc/59d6e4ccb48e17f64258ccda6f5d8407 to your computer and use it in GitHub Desktop.

Download ZIP

oracle flashback query

Raw

as-of-timestamp.sql

	select * from some_tbl
	AS OF TIMESTAMP TO_TIMESTAMP('2019-12-10 22:00:12', 'YYYY-MM-DD HH24:MI:SS');

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment