allanfreitas/gist:7f5e4d88c0e6228f450f7fb59644470a

Forked from andreia/gist:3354204

Created June 30, 2016 12:50

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

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

Download ZIP

ORACLE: Show size in Kb of BLOB fields

Raw

gistfile1.sql

SELECT round(DBMS_LOB.getlength(A.FILE)/1024) KB FROM MY_TABLE A

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