Exclusive aggregation using the clustering technique : Cluster « Table « Oracle PL/SQL Tutorial






SQL>
SQL>
SQL> CREATE TABLE Hard_Disk
  2     (hd_id            VARCHAR2(10) NOT NULL,
  3      capacity         VARCHAR2(20),
  4      PRIMARY KEY (hd_id))
  5     CLUSTER Part_Cluster(hd_id);

Table created.

SQL>
SQL> CREATE TABLE PartType
  2     (hd_id            VARCHAR2(10) NOT NULL,
  3      PartType_id      VARCHAR2(10) NOT NULL,
  4      description      VARCHAR2(25),
  5      PRIMARY KEY (PartType_id),
  6      FOREIGN KEY (hd_id) REFERENCES Hard_Disk (hd_id))
  7     CLUSTER Part_Cluster(hd_id);

Table created.

SQL>
SQL> drop table Hard_Disk  cascade constraints;

Table dropped.

SQL> drop table PartType cascade constraints;

Table dropped.

SQL>








6.24.Cluster
6.24.1.Create cluster and set hashkeys, size
6.24.2.Create cluster and then create table on top of it
6.24.3.Cluster with varchar2 column
6.24.4.drop cluster
6.24.5.Existence-dependent aggregation using the clustering technique
6.24.6.Exclusive aggregation using the clustering technique
6.24.7.Create index on cluster