神通数据库7.0使用版下载地址

~贝贝~

旷野玫瑰 发表于 2012-2-8 12:42
达梦的奖品还没有收到，现在又有神通数据库的试用了，不知楼主有啥奖品不？

恩，我让论坛助理小草mm站内短信联系你，要是你回复了快递信息的，就都发了！希望不是快递递丢了，呵呵

wxz317

myth8860 发表于 2012-2-8 15:44
奖品不太给力，puber们都比较挑剔，建议搞点有实际应用价值的奖品。

神七和嫦娥的模型估计市面上很难买到吧
这是收藏用的
你们的MP4我觉得一点都不实惠，现在谁还用啊

〇〇

收藏用

〇〇

示例
使用SYS_CONNECT_BY_PATH的实例



查询语句如下：

SELECT employee_id, last_name, manager_id, SYS_CONNECT_BY_PATH ( last_name,'/') "path" from EMPLOYEES CONNECT BY PRIOR employee_id = manager_id order by "path";

〇〇

关闭数据库系统

l 语法

SHUTDOWN [ IMMEDIATE | ABORT | TRANSACTIONAL | NORMAL ] ;

〇〇

<table_partitioning_clauses>::=

{<range_partitions>|<hash_partitions>|<list_partitions>}

<range_partitions>::=PARTITION BY RANGE({column_name}[,…n]) ({PARTITION [partition_name] <range_values_clause> <table_partition_description>}[,…n])

<range_values_clause>::= VALUES LESS THAN ({MAXVALUE|literal }[,…n])

<list_partitions>::= PARTITION BY LIST (column_name) ({PARTITION [partition_name] <list_values_clause> <table_partiton_description>}[,…n] )

<list_values_clause>::= VALUES ({DEFAULT|{NULL|literal}[,…n]})

<hash_partitions>::=PARTITION BY HASH({column_name}[,…n]) {<individual_hash_partitions>|<hash_partition_by_quantity>}

<individual_hash_partitions>::=

({PARTITION [partition_name] [<table_partition_description>]}[,…n])

<hash_partition_by_quantity>::=PARTITIONS hash_partition_quantity [STORE IN ({tablespacename}[,…n])]

<table_partition_description>::= [<table_storage_option>] [<lob_storage_definition>]

〇〇

下例显示创建含有垂直分区信息的完整表定义：

CREATE TABLE Partition_Data

       (PARTITION b_par : b int,

        PARTITION c_par : c int,

        d int,

        PARTITION e_par : e int)

PARTITION b_par logging init 10m next 10m MAXSIZE UNLIMITED

PARTITION c_par init 10m next 10m MAXSIZE 100m;