INFORMATION_SCHEMA views in Oracle

From: Craig Warman <crwarman_at_yahoo.com>
Date: 29 Oct 2004 15:09:11 -0700
Message-ID: <a24e13f4.0410291409.7ba18924@posting.google.com>

I'm working on a MS SQL to Oracle migration project for a Perl-based system. This system makes use of the INFORMATION_SCHEMA metadata implementation in MS SQL. I'd like to emulate that in an Oracle 9.2.0.4 instance, which (I believe) means I'll need to develop some equivalent views in a schema of that name.

I've done a good bit of searching, and found a posting in this forum by Peter Weighill (link below) that provides a starting point. But before I go re-inventing the wheel, has anyone come up with anything more comprehensive than what Peter posts there? If so, I'd like to build on that if I could.

Here's a link to the above-mentioned post: http://groups.google.com/groups?hl=en&lr=&selm=ca4tin%24sca%241%40hercules.btinternet.com

Also, if this post comes to the attention of Peter Weighill, just wanted to pass on my thanks for his having shared that info.

Craig Received on Fri Oct 29 2004 - 17:09:11 CDT