oracle获取主键sql,关于Oracle与SqlServer中获取所有字段、主键、外键

2、主键(参考SqlServer系统存储过程sp_pkeys)：select COLUMN_NAME = convert(sysname,c.name)

from

sysindexes i, syscolumns c, sysobjects o

where o.id = object_id('[YourTableName]')

and o.id = c.id

and o.id = i.id

and (i.status & 0x800) = 0x800

and (c.name = index_col ('[YourTableName]', i.indid,  1) or

c.name = index_col ('[YourTableName]', i.indid,  2) or

c.name = index_col ('[YourTableName]', i.indid,  3) or

c.name = index_col ('[YourTableName]', i.indid,  4) or

c.name = index_col ('[YourTableName]', i.indid,  5) or

c.name = index_col ('[YourTableName]', i.indid,  6) or

c.name = index_col ('[YourTableName]', i.indid,  7) or

c.name = index_col ('[YourTableName]', i.indid,  8) or

c.name = index_col ('[YourTableName]', i.indid,  9) or

c.name = index_col ('[YourTableName]', i.indid, 10) or

c.name = index_col ('[YourTableName]', i.indid, 11) or

c.name = index_col ('[YourTableName]', i.indid, 12) or

c.name = index_col ('[YourTableName]', i.indid, 13) or

c.name = index_col ('[YourTableName]', i.indid, 14) or

c.name = index_col ('[YourTableName]', i.indid, 15) or

c.name = index_col ('[YourTableName]', i.indid, 16)

)