Skip to content

Instantly share code, notes, and snippets.

@BrunoCaimar

BrunoCaimar/oracle_recipes.md

Last active January 6, 2020 17:20
Show Gist options
  • Save BrunoCaimar/75533ff972e9c78d8650fbb62771cb8a to your computer and use it in GitHub Desktop.
Save BrunoCaimar/75533ff972e9c78d8650fbb62771cb8a to your computer and use it in GitHub Desktop.
Download ZIP
Oracle PL/SQL Recipes
Raw
oracle_recipes.md

Oracle recipes

Columns

  • ALL_TAB_COLUMNS / DBA_TAB_COLUMNS / USER_TAB_COLUMNS
select C.*, T.* from DBA_TAB_COLUMNS C JOIN DBA_TABLES T ON T.TABLE_NAME = C.TABLE_NAME
where column_name like '%UTD%'
order by C.table_name, column_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment