Forums | Admin

Discussion Forums: help

Start New Thread Start New Thread

 

By: Kubo Takehiro
RE: Getting at constraint metadata [ reply ]  
2010-09-25 14:34
You need to retrieve constraint and primary key information from data dictionary views.

OCI8::Metadata uses OCIDescribeAny(). They are not listed in the following page:
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10646/oci06des.htm

By: Daniel Berger
RE: Getting at constraint metadata [ reply ]  
2010-09-21 19:22
Along those same lines, is there an easy way to determine the primary key for a given table using one of the OCI8::Metadata classes?

Thanks,

Dan

By: Daniel Berger
Getting at constraint metadata [ reply ]  
2010-09-21 19:18
Hi,

Using ruby-oci8 2.x, is there a way to get at constraint information for a given table? I've looked at the methods for OCI::Metadata::Table and OCI::Metadata::Column, and the names of the other various metadata classes, but nothing lept out at me.

Regards,

Dan