More on Sample Data
In my blog post Writing Fast Queries the first point is to have a lot of sample data. APEX Instant Tips episode 85 describes the Oracle APEX Data Generator and Sandra Suarez has a great post on the topic. Sometimes, though, you just want some good data that you can reference in your own queries. You may want to generate sample data into your tables, or just query the data for a demo. Once you have APEX installed, you have access to a lot of great sample data--you just need to know where to look.
select view_name
from all_views
where view_name like 'APEX_DG_BUILTIN%'
order by view_name
The query above returns 29 views full of great sample data.
| VIEW_NAME | CT |
| APEX_DG_BUILTINS | 193 |
| APEX_DG_BUILTIN_2D_SHAPES | 26 |
| APEX_DG_BUILTIN_3D_SHAPES | 20 |
| APEX_DG_BUILTIN_AIRPORTS | 500 |
| APEX_DG_BUILTIN_ANIMALS | 500 |
| APEX_DG_BUILTIN_BOOLEANS | 4 |
| APEX_DG_BUILTIN_CARS | 151 |
| APEX_DG_BUILTIN_COLORS | 15 |
| APEX_DG_BUILTIN_COMPANY_NAMES | 750 |
| APEX_DG_BUILTIN_COUNTRIES | 227 |
| APEX_DG_BUILTIN_DEPTS | 15 |
| APEX_DG_BUILTIN_ELEMENTS | 117 |
| APEX_DG_BUILTIN_FONTAPEX | 1165 |
| APEX_DG_BUILTIN_FOODS | 263 |
| APEX_DG_BUILTIN_GENERIC_PRODS | 2652 |
| APEX_DG_BUILTIN_ICD_DIAGS | 160 |
| APEX_DG_BUILTIN_ICD_PROCS | 150 |
| APEX_DG_BUILTIN_INDUSTRIES | 99 |
| APEX_DG_BUILTIN_ISLANDS | 51 |
| APEX_DG_BUILTIN_LANGUAGES | 138 |
| APEX_DG_BUILTIN_LATIN_TEXTS | 50 |
| APEX_DG_BUILTIN_LOCATIONS | 469 |
| APEX_DG_BUILTIN_OCCUPATIONS | 101 |
| APEX_DG_BUILTIN_PERSONS | 750 |
| APEX_DG_BUILTIN_PETS | 324 |
| APEX_DG_BUILTIN_PLANTS | 101 |
| APEX_DG_BUILTIN_PRODUCTS | 0 |
| APEX_DG_BUILTIN_PROD_REVIEWS | 100 |
| APEX_DG_BUILTIN_SCHOOLS | 500 |
| APEX_DG_BUILTIN_STATUS | 4 |
As of now the data is all in English, but there is an internal API to add data in additional languages and the Data Generator APIs all support data in additional languages.