oracle联合主键和联合索引,联合主键自动创建索引，建表时也可指定索引

[code]C:\\Documents and Settings\\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 8月 20 11:05:43 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

连接到:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

orcl OPEN

SQL> conn awen/oracle

已连接。

SQL> select object_name from all_objects where object_type='INDEX' and owner='A

WEN';

OBJECT_NAME

------------------------------

SYS_C005556

SYS_C005558

OB_INDEX

SQL> create table index_text ( id integer,name varchar2(10), tel varchar2(11)

,constraint in_pk primary key (id,name));