Cluster with varchar2 column : Cluster « Table « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table
  3. Cluster

Cluster with varchar2 column

   

SQL>
SQL>
SQL> create cluster lookup_hash_cluster(
  2      key_col varchar2(30)
  3  )
  4  single table
  5  hashkeys 20000
  6  size 255
  7  /

Cluster created.

SQL>
SQL> drop cluster lookup_hash_cluster;

Cluster dropped.








Related examples in the same category

1.create cluster
2.Create cluster and set hashkeys, size
3.Create cluster and then create table on top of it
4.Exclusive aggregation using the clustering technique
5.Existence-dependent aggregation using the clustering technique
6.Oracle provides a clustering technique that can be very useful for an aggregation relationship.
7.drop cluster