Skip to content

Instantly share code, notes, and snippets.

@IngmarBoddington
Last active April 17, 2020 12:59
Show Gist options
  • Save IngmarBoddington/a2eb936d0edb9ff418d3cd29824453ca to your computer and use it in GitHub Desktop.
Save IngmarBoddington/a2eb936d0edb9ff418d3cd29824453ca to your computer and use it in GitHub Desktop.
Example limit
SELECT * FROM <table> WHERE rownum <= 1;
Example row size
SQL> SELECT AVG_ROW_LEN FROM dba_tables WHERE table_name = '<table>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment