Skip to content

Instantly share code, notes, and snippets.

@ecormaksin

ecormaksin/oracle_get_tables_columns.sql

Created February 28, 2020 00:48
Show Gist options
  • Save ecormaksin/0de41a70e4945318b3a818b9fedf274d to your computer and use it in GitHub Desktop.
Save ecormaksin/0de41a70e4945318b3a818b9fedf274d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle_get_tables_columns.sql
SELECT
TABLE_NAME,
COLUMN_NAME
--DATA_TYPE,
--DATA_TYPE_MOD,
--DATA_TYPE_OWNER,
--DATA_LENGTH,
--DATA_PRECISION,
--DATA_SCALE,
--NULLABLE,
--COLUMN_ID,
--DEFAULT_LENGTH,
--DATA_DEFAULT AS DATA_DEFAULT,
--NUM_DISTINCT,
--LOW_VALUE,
--HIGH_VALUE,
--DENSITY,
--NUM_NULLS,
--NUM_BUCKETS,
--LAST_ANALYZED,
--SAMPLE_SIZE,
--CHARACTER_SET_NAME,
--CHAR_COL_DECL_LENGTH,
--GLOBAL_STATS,
--USER_STATS,
--AVG_COL_LEN,
--CHAR_LENGTH,
--CHAR_USED,
--V80_FMT_IMAGE,
--DATA_UPGRADED,
--HISTOGRAM
FROM
USER_TAB_COLUMNS
WHERE (1 = 1)
and TABLE_NAME not in (select view_name from user_views)
ORDER BY
TABLE_NAME
,COLUMN_ID
,COLUMN_NAME
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment