Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old February 11th, 2004, 05:09 AM
Authorized User
 
Join Date: Jun 2003
Location: Bombay, Maharashtra, India.
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.
Reply With Quote
  #2 (permalink)  
Old February 25th, 2004, 02:08 PM
Authorized User
 
Join Date: Feb 2004
Location: Leeds, West Yorkshire, United Kingdom.
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!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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



All times are GMT -4. The time now is 10:25 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.