Skip to content

Instantly share code, notes, and snippets.

@vivainio

vivainio/oracle_killer.sql

Created June 25, 2019 07:33
Show Gist options
  • Save vivainio/01dc2399e829abc3ebfba4837378cf9c to your computer and use it in GitHub Desktop.
Save vivainio/01dc2399e829abc3ebfba4837378cf9c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle_killer.sql
select * from
(
select ALL_TAB_COLUMNS.COLUMN_NAME as COLUMN_NAME, ALL_TAB_COLUMNS.TABLE_NAME as TABLE_NAME, ALL_TAB_COLUMNS.DATA_TYPE as DATA_TYPE, JOINED_TABLE_NAME.TABLE_NAME as TABLE_NAME_TABLE_NAME
from ALL_TAB_COLUMNS
LEFT OUTER join ALL_TABLES JOINED_TABLE_NAME on ALL_TAB_COLUMNS.TABLE_NAME=JOINED_TABLE_NAME.TABLE_NAME
) rootq
order by 1 ASC
offset 5000 rows fetch next 2000 rows only
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment