Skip to content

Instantly share code, notes, and snippets.

@terrancesnyder

terrancesnyder/oracle-generate-numeric-range.sql

Created February 3, 2012 18:38
Show Gist options
  • Save terrancesnyder/1731650 to your computer and use it in GitHub Desktop.
Save terrancesnyder/1731650 to your computer and use it in GitHub Desktop.
Download ZIP
oracle generate numeric range
Raw
oracle-generate-numeric-range.sql
select shard
FROM (select 0 shard from dual) shards
MODEL
DIMENSION BY (shard)
MEASURES (shard v)
RULES UPSERT
(v[for shard from 0 to 100 increment 1] = 1)
order by 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment