구문
>>-CREATE--+----------+---TABLE--table-name--------------------->
'-SUMMARY--'
>-----+-| element-list |------------------------------+--------->
+-OF--type-name1--+--------------------------+--+
| '-| typed-table-options |--' |
+-| summary-table-definition |------------------+
'-LIKE--+-table-name1-+---+-------------------+-'
+-view-name---+ '-| copy-options |--'
'-nickname----'
.-DATA CAPTURE NONE----.
>----*--+----------------------+--*----------------------------->
'-DATA CAPTURE CHANGES-'
>-----+-----------------------------------------------+--*------>
'-IN--tablespace-name1--| tablespace-options |--'
>-----+------------------------------------------------------------+>
| .-,---------. |
| V | .-USING HASHING--. |
+-PARTITIONING KEY--(-----column---+---)--+----------------+-+
'-REPLICATED-------------------------------------------------'
>----*--+----------------------+---*---------------------------><
'-NOT LOGGED INITIALLY-'
element-list
.-,---------------------------------.
V |
|---(------+-| column-definition |------+--+---)----------------|
+-| unique-constraint |------+
+-| referential-constraint |-+
'-| check-constraint |-------'
typed-table-options
|---+----------------------------+---+-------------------------+->
+-HIERARCHY--hierarchy-name--+ '-| typed-element-list |--'
'-| under-clause |-----------'
>---------------------------------------------------------------|
under-clause
|---UNDER--supertable-name--INHERIT SELECT PRIVILEGES-----------|
typed-element-list
.-,--------------------------------.
V |
|---(------+-| OID-column-definition |-+--+---)-----------------|
+-| with-options |----------+
+-| unique-constraint |-----+
'-| check-constraint |------'
summary-table-definition
|--+----------------------------+---AS--(--fullselect--)--| summary-table-options |-->
| .-,--------------. |
| V | |
'-(-----column-name---+---)--'
>---------------------------------------------------------------|
너무산만해서 이해가안되요
|--+----------------------------+---
| .-,--------------. |
| V | |
'-(-----column-name---+---)--'
보기가 너무어려운거 같아요 쉽게 설명좀해주실수있는지 고수님들부탁해요
|