Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    9

    Question Unanswered: data dictionary views

    I would like to know what are helpful data dictionary views for use with DML in Oracle. For example, if a programmer wants to write applications that perform DML actions on rows from tables in the database, what are some views that would be helpful?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    It depends on what you are trying to do. Not all tasks will require your favourite set of views. I agree, there are far to many of them to know them all (check this page, for example), but I don't have a digest list.

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    In 10g at least (I haven't worked with earlier versions):
    Code:
    SQL> desc dictionary
     Name                                      Null?    Type
     ----------------------------------------- -------- ----------------------------
     TABLE_NAME                                         VARCHAR2(30)
     COMMENTS                                           VARCHAR2(4000)
    
    SQL> select * from dictionary;
    
    TABLE_NAME            COMMENTS
    ----------            --------
    DBA_ROLES             All Roles which exist in the database
    DBA_PROFILES          Display all profiles and their limits
    ...
    I usually search on a key word, or part of that word, in order to find the views that might help. Like, if I was interested in building a script that would drop triggers for all tables in a schema, I'd probably start with

    Code:
    SQL> select table_name from dictionary where table_name like '%TRIG%';
    
    TABLE_NAME
    ------------------------------
    USER_TRIGGERS
    ALL_TRIGGERS
    DBA_TRIGGERS
    USER_INTERNAL_TRIGGERS
    ALL_INTERNAL_TRIGGERS
    DBA_INTERNAL_TRIGGERS
    USER_TRIGGER_COLS
    ALL_TRIGGER_COLS
    DBA_TRIGGER_COLS
    
    9 rows selected.
    -cf
    Last edited by chuck_forbes; 09-27-06 at 11:46.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •