Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 11th, 2004, 06:09 AM
Authorized User
 
Join Date: Jun 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data Dictionary

hi,

I just want to know whether there is any site or help available that gives with example for dict. I mean in sqlplus when we type select * from dict. The tablename displayed with comments is not enough to understand.

So I am looking for a site that gives in depth or in detail about dict and when and how to use them.

Thanks in advance.
 
Old February 25th, 2004, 03:08 PM
Authorized User
 
Join Date: Feb 2004
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Have you tried the Oracle website?

THe data dictionary is a vast thing to mess around with.. generally there are a number of tables you'll find useful,
user_indexes,
user_tables,
user_objects,
(then replace user with all_etc)
A good source would be Oracle DBA books by Osborne (publishers), they're expensive so join the local library.
I'm afraid it took me the best part of a degree to work out how to use Oracle and the Data Dictionary effectively so be prepared to spend some time on this one!!

Simon



Don't think, do!





Similar Threads
Thread Thread Starter Forum Replies Last Post
The given key was not present in the dictionary charnata ASP.NET 2.0 Professional 1 May 26th, 2006 12:07 PM
using dictionary object rajiv_software Classic ASP Basics 4 June 21st, 2005 02:53 PM
Cookie Dictionary Question johne Classic ASP Basics 0 April 18th, 2005 05:57 PM
Scripting Dictionary sachindhillan Classic ASP Basics 0 August 17th, 2004 09:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.