Data dictionary...question

[softdrink]

I need a link or information on various data dictionary commands for SQLPlus ( oracle 8i ).

thank,

softdrink

 

[stefanhei]

I think the best source of information is Oracle itself:

http://tahiti.oracle.com/pls/tahiti/tahiti.homepage?remark=tahiti

Stefan

 

[rcurva]

What do you mean by data dictionary commands, could you give an example? Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[softdrink]

sure....in SQLPlus I want to access certain data dictionary ie: user_tabkes or constraint_name etc. basically to verifiy what I'm doing or to verify information on tables, users, constraints on other tables.

softdrink

 

[rcurva]

You can use the DICTIONARY or DICT view to know all data dictionary views available in your database. There are definitions of each view available there.

From your sqlplus,

select *
from DICT
where table_name like 'USER_%';

I just hope this is what you are looking for.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War