1CREATE DATABASE numismatics;  /*+ CACHESIZE = 16m */
2
3CREATE TABLE coin (cid INT(8) PRIMARY KEY,
4                       unit VARCHAR(20));
5
6
7CREATE INDEX ON coin(unit);
8
9