Base tables for Blog entries

In the blog / wiki I often use test tables. These tables are created under scott/tiger as follows:

create table ot_vc (dummy varchar2(200));

create table ot_nb (dummy number);

create table ot_dt (dummy date);

create table ot_ts (dummy timestamp);

create table ot_cmp (dummy_vc varchar2(200), dummy_nb number, dummy_dt date, dummy_ts timestamp);

For future blog posts, I will extend this datamodel with extra tables, indexes and data generation.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.