RichVRed/column_info.sql

Forked from ryanthames/column_info.sql

Created April 28, 2017 23:55

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

Select an option

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

Download ZIP

Oracle - Column Information (https://app.pluralsight.com/library/courses/oracle-performance-tuning-developers/table-of-contents)

Raw

column_info.sql

	select column_name, avg_col_len, num_distinct, num_nulls
	from all_tab_columns
	where table_name = '<<table name>>'
	order by column_id desc;

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