Re: how can I determine the primary key for a table?

Here's a totally different approach:

select dbms_metadata.get_ddl('TABLE', 'TABLE_H') from dual

Of course, in this case the user needs access to the package.

Kind regards

        robert Received on Fri Apr 03 2009 - 01:54:17 CDT